This is an amazing feature but you need at least two RAC nodes configured to use it, see below: Output of TimesTen 11.2 installation … Would you like to use TimesTen Replication with Oracle Clusterware? [ no ] yes Please provide the path to the Oracle Clusterware installation on this machine (s=skip)? [ ] /app/oracle/product/11.2.0/gridhome ...
Yes, it does. Capture is still not supported by GoldenGate, but I know Oracle actually is evaluating the possibility. Sources From an old GoldenGate WhitePaper (This WP was wrote before Oracle acquire TimesTen) … Comprehensive Platform Support GoldenGate can replicate data bi-directionally between any combination of Oracle, DB2,Microsoft SQL Server, Sybase, Informix, NonStop SQL and ...
Finally… packages and store procedures, what a change !!! Enhacements Access Control PL/SQL support Oracle In-Memory Database Cache (IMDB Cache) Asynchronous materialized views RETURNING … INTO clause ROWID data type Duplicate parameter names Bitmap indexes Set operators in subqueries Enhanced “:” parameter markers Multiline C-style comments View and sequence names http://download.oracle.com/docs/cd/E13085_01/doc/timesten.1121/e13070/whatsnew.htm#insertedID11 ...
Probably you want to know how much memory it is needed to buy your TT server or you just wants to estimate what will happen if you’ve millions of rows in two months, you’re in lucky, there is a very easy way to do this, using a nice tool called ”ttSize”. ttSize is an utility program ...
Below the Oracle data types unsupported by TimesTen (Valid 7.0.x and up) 01. ROWID 02. UROWID 03. CLOB 04. NCLOB 05. BLOB 06. BFILE 07. REF “Any” types 08. XML types 09. Spatial types 10. Media types 11. TT_TINYINT 12. TT_SMALLINT 13. TT_INTEGER 14. TT_BIGINT 15. TT_VARBINARY 16. TIMESTAMP WITH TIME ZONE 17. TIMESTAMP WITH ...
Fast Application Notification (FAN) Yes, it’s recommended and it’s a good practice to use it in your RAC enviroment because Cache connect uses OCI integrated with FAN to receive notifications of Oracle events, believe or not, visiting some customers I could adivise that ons demons were disable or going down for known bugs. FAN is ...