1 person found this helpful
1. The current (184.108.40.206.0) release of In-Mmemory Database ache supports the following Oracle database versions:
- Oracle Database 10g Release 2 (10.2.0.5.0 or above)
- Oracle Database 11g Release 1 (220.127.116.11.0 or above)
- Oracle Database 11g Release 2 (18.104.22.168.0 or above)
- Oracle Database 12c
2. I'm not sure what you mean by 'move them ONLY'. In-memory database cache caches tables so you would cache just those 30 tables, but they would also still exist in Oracle of course (they are cached, not moved).
3. Oracle In-Memory Database Cache provides sophisticated functionality to synchronise data between Oracle Database and the In-Memory Cache. You do not need to write anything.
4. For writeable caches, TT -> Oracle sync is continuous/ real-time. For readonly caches, Oracle -> TT sync is time driven with a granularity down to 10s of milliseconds.
5. Not sure what you mean. The Oracle In-Memory Database cache is a DB EE option. It is actually exactl the same as the TimesTen In-Memmory Database, it is just a different mode of licensing.
6. TimesTen/In-Memory Database Cache includes a sizing tool (ttSize) that will help you to determine how much memory you will need.
Thankyou for your help . Please see my comments below
(Chris answer) 2. I'm not sure what you mean by 'move them ONLY'. In-memory database cache caches tables so you would cache just those 30 tables, but they would also still exist in Oracle of course (they are cached, not moved).
My Question is . Can i write update statement on the Cached Table? In other words, can i perform DML on Cached Tables?
NOTE: My issue is that, there are around 30 tables , that might have performance issue. I want to Cache ONLY those tables and want to do UPDATE/DELETE/INSERT
on these( 30 tables) and also SELECT statement
My Question: What will be Licensing Cost? In other words, i have a client that is using 11g database and How much more , should he needs to PAY to use TimesTen , In Memory Database?
If you configure writethrough cache groups then yes you can do DML and SELECT on the cached tables in the TimesTen In-Memory Database Cache.
TimesTen / In-Memory Database Cache is licensed on the same basis just like most other Oracle software. For the current pricing please consult the published price list or talk to your Oracle sales person.
Can we store and execute Procedures/Packages in Timeten IMDB?