Database Software

Hi there,

I have an Oracle 11g db and I’m considering installing the Oracle TimesTen In-Memory Database Cache (v11.2) to increase the general performance but, after reading the Oracle documentation and the information I found in internet I have some doubts that maybe you can clarify for me:

• What happens with all the PL/SQL procedures, triggers and packages stored in the DB and with the OS scripts? I mean, Will they continue working without any change from my side or I need to do changes?

This question comes because I have read that exist problems of compatibility between TimesTen and Oracle like problems with Roles, Profiles, Tablespaces, Rollback Segments, etc, besides having differences between some data types.

• What happens with the JAVA and C applications that connect to the db which I have already developed and working? I mean, Will they continue being able to send the same SQL statements to the DB?

From what I have seen so far, it seems the only thing I have to do is to change the local ODBC client driver to point to the TimesTen db server and after that, by means of the Passthrough Feature, every SQL statement incoming will be executed on the TimesTen db if possible and redirected to the Oracle db in other case. Is that correct or I have to change the apps code?

• Is it possible to use TOAD to connect and configure the TimesTen db or I have to use SQL Developer? I see that I need to perform some configuration steps on SQL Developer before being able to use it with TimesTen db.

• Is there any other problem about compatibilities that I’m missing and I should take in consideration?

Thanks in advance.