|Oracle® In-Memory Database Cache Introduction
11g Release 2 (11.2.2)
This section summarizes the new features of Oracle TimesTen In-Memory Database release 11.2.2 that are described in this guide. It provides links to more information.
ttStats utility is used for collection and display of database statistics. You can evaluate the collected statistics to evaluate the performance of your TimesTen database. See "Administration and utilities".
You can apply hints to pass instructions to the TimesTen query optimizer. The optimizer considers these hints when choosing the best execution plan for your query. In this release, you can apply a statement level optimizer hint for a particular SQL statement. For details, see "Optimizer hints".
You can use new built-in procedures to measure and display execution time statistics for SQL operations to determine the performance of SQL statements. See "System monitoring".
A new tool, the Index Advisor, can be used to recommend a set of indexes that could improve the performance of a specific SQL workload. For more details, see "Indexes".
New tools have been added that enable you to load the results of a SQL query from a back-end Oracle database into a single table on TimesTen. For more information, see "Load data from an Oracle database into a TimesTen table".
A new tool, the Oracle IMDB Cache Advisor, enables Oracle Database customers to determine whether the performance of an existing Oracle Database application can be improved if the application is used with Oracle IMDB Cache. For more information, see "Using the Cache Advisor".
You can increase replication throughput by configuring parallel replication at database creation time. See "Replication".
You can increase throughput from asynchronous writethrough (AWT) cache groups to the Oracle database by configuring parallel propagation at database creation time. See "Updating the Oracle database tables from a cache group".
TimesTen provides the ability to compress tables at the column level, thus storing the data more efficiently. See "In-memory columnar compression".
TimesTen provides analytic SQL functions, aggregate SQL functions and OLAP operators. See "Business intelligence and online analytical processing".
TimesTen supports large objects (LOBs) in tables that are not cached in the IMDB Cache. See "Large objects".