Skip Headers
Oracle® TimesTen In-Memory Database Operations Guide
Release 11.2.1

Part Number E13065-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

What's New

This section summarizes the new features and functionality of Oracle TimesTen In-Memory Database Release 11.2.1 that are documented in this guide, providing links into the guide for more information.

New features for release 11.2.1

This guide has information about the following new features:

Access control

Oracle TimesTen In-Memory Database release 11.2.1 has a new access control model. The previous TimesTen access control model has been removed. There is no backwards compatibility between the two models.

Users are defined at the database level rather than at the installation level. Privileges are defined at the object level. The system privileges in TimesTen release 7.0 and previous releases have been replaced with system privileges that are similar to Oracle database system privileges.

The main changes to access control in this release are as follows:

For details on creating users and assigning privileges for access to database objects, see Chapter 4, "Managing Access Control".

Asynchronous materialized views

Materialized views can be refreshed asynchronously at either a specified time or through manual initiation. You can either have the deferred transactions updated incrementally or with a complete refresh. A materialized view log is created and associated with the asynchronous materialized view to facilitate the incremental refresh of data from the detail tables. For full details, see "Understanding materialized views" and "Working with materialized views".

SQL command cache

All commands executed—SQL statements, built-in procedures, and so on—are stored in the SQL Command Cache, which uses temporary memory. The commands are stored up until the limit of the SQL Command Cache is reached, then the new commands are stored after the last used commands are removed. You can retrieve one or more of these commands that are stored in the SQL Command Cache. For full details on the SQL command cache, see "Viewing SQL commands stored in the SQL Command Cache".

You can also view the query plan information to monitor and troubleshoot your queries. For details, see "Viewing query plans associated with commands stored in the SQL Command Cache".

Bitmap indexes

TimesTen supports bitmap indexes. See "Overview of index types".

Transaction log buffer file size

The configuration for the transaction log buffer file size has been modified from LogBuffSize, which was defining the size in KBs, to LogBufMB, which defines the transaction log buffer size in MBs. This affects how you configure the data store size, as described in "Changing data store size". Use the LogBufMB to configure performance, as described in "Increase LogBufMB if needed".

Automatic client failover

You can configure automatic client failover for data stores that have active standby pair replication schemes. This enables the client to fail over automatically to the server on which the standby data store resides. See "Configuring automatic client failover".

PL/SQL support

You can specify values for PL/SQL connection attributes in a data source name (DSN). See "Specifying PL/SQL connection attributes in a DSN".

You can use the ttIsql utility to create and execute PL/SQL blocks. See "Creating and executing PL/SQL blocks" and "Using OUT parameters".

You can use the ttIsql utility to display PL/SQL objects. See "Displaying information about PL/SQL objects".

Replication performance

Use the RecoveryThreads first connection attribute to increase performance of active standby pairs. See "Increase replication throughput for active standby pairs".