Oracle® TimesTen In-Memory Database Historical Release Notes
Release 11.2.2
 

 

Oracle® TimesTen In-Memory Database

Historical Release Notes

Release 11.2.2

 

May 2014

This document provides historical release information for TimesTen release 11.2.2.1.0 through 11.2.2.5.0, including older information that has been removed from the release notes.

Information about TimesTen 11.2.2 releases 11.2.2.6.0 and later can be found in the readme.html file in your installation directory. Release notes may also be updated from time to time in the documentation library at http://www.oracle.com/technetwork/products/timesten/documentation/.

To install the Oracle TimesTen In-Memory Database, run setup from the installation media pack. For installation information, see Oracle TimesTen In-Memory Database Installation Guide. This guide can be accessed from install_dir/doc/index.htm at the root of the installation media pack.

This document contains the following sections:

1 Changes in this release

This section lists changes between releases:

1.1 Changes for Release 11.2.2.5.0 from Release 11.2.2.4.5

Changes in this release include:

1.1.1 Behavior Changes

  • Beginning in Release 11.2.2.2.0, the PreparedStatement.setBoolean (int parameter, false) method sets the specified column to 0 irrespective of the data type. In previous releases, PreparedStatement.setBoolean (int parameter, false) set CHAR/VARCHAR/NCHAR/NVARCHAR columns to NULL.

  • In this release, the default TABLE DEFINITION CHECKING setting for databases in a replication scheme changes from the current default of EXACT to RELAXED.

  • In previous releases, TimesTen checked that all AWT cache groups had matching unique indexes and unique constraints with the corresponding Oracle database tables. If there were any missing constraints, TimesTen did not allow propagation to the Oracle database.

    In this release, TimesTen checks that all AWT cache groups have matching unique constraints and foreign key constraints with the corresponding Oracle database tables. If there are any missing constraints, TimesTen issues a warning and propagation to Oracle occurs automatically. However, updates to these TimesTen AWT cache group tables with the missing constraints are serially applied to the Oracle database, rather than being applied in parallel.

    You can manually initiate a check for missing constraints with the ttCacheCheck built-in procedure. See Oracle In-Memory Database Cache User's Guide and Oracle TimesTen In-Memory Database Reference.

1.1.2 New Features

1.1.2.1 Performance Enhancements
  • TimesTen has added the CommitBufferSizeMax connection attribute to allow users to configure the size of the transaction commit buffer to improve the performance of commit or rollback of large transactions. See details about the ttCommitBufferStats and ttCommitBufferStatsReset built-in procedures and the CommitBufferSizeMax connection attribute in the Oracle TimesTen In-Memory Database Reference. Also see the Oracle TimesTen In-Memory Database Operations Guide. See the Oracle TimesTen In-Memory Database SQL Reference for information on settings in the ALTER SESSION statement.

  • TimesTen now supports B-tree indexes. B-tree indexes and T-tree indexes both are referred to as Range Indexes. In some cases, B-tree indexes offer concurrency advantages over T-trees. The RangeIndexType data store connection attribute determines whether user-created range indexes are T-tree indexes or B-tree indexes. For details, see the Oracle TimesTen In-Memory Database SQL Reference and the Oracle TimesTen In-Memory Database Operations Guide for details.

  • In previous releases, TimesTen only supported hash indexes on primary key columns. You can use the CREATE [UNIQUE] HASH INDEX statement to create a hash index on the columns specified. For details, see the Oracle TimesTen In-Memory Database SQL Reference.

  • You can perform multiple concurrent inserts on table that has compressed columns. In previous releases, TimesTen held a table lock on tables that contained compressed columns, allowing only single inserts on these tables. For more information on compressed tables, see the Oracle TimesTen In-Memory Database SQL Reference.

1.1.2.2 Performance Monitoring
  • A new utility, ttStats, provides the ability to monitor TimesTen database activities. The ttStats utility supports real-time monitoring, capturing snapshots of system statistics, and generating user-friendly HTML reports for performance analysis. In addition, a new PL/SQL package TT_STATS is available for custom development of monitoring functions. The ttStats utility is a stand-alone facility for the TimesTen database. It is a complementary utility to the Enterprise Manager Plugin for TimesTen. See the Oracle TimesTen In-Memory Database Reference and the Oracle TimesTen In-Memory Database PL/SQL Packages Reference.

  • There is a new option, -logAnalyze, in the ttXactLog utility that analyzes the pending log records to be transmitted from the master to any receivers. This is useful, for instance, to determine how much is left to be replicated from a transmitter to a given receiver. See the Oracle TimesTen In-Memory Database Reference and the Oracle TimesTen In-Memory Database Operations Guide.

  • TimesTen added the ability to measure and display the execution time of SQL statements through the new built-in procedure ttSQLCmdCacheInfo2. For details, see the Oracle TimesTen In-Memory Database Reference and the Oracle TimesTen In-Memory Database Operations Guide.

1.1.2.3 Cache and Replication
  • The built-in procedure ttDBConfig supports a new parameter, CacheParAwtBatchSize. This parameter configures the maximum number or rows included in a single batch. The ability to configure the number of rows is useful for propagating large numbers of rows to the Oracle database from an AWT cache group. See the Oracle TimesTen In-Memory Database Reference.

  • TimesTen could potentially run out of temporary or permanent space when applying a large incremental autorefresh transaction. For these situations, you can configure an autorefresh transaction limit, where the large amount of data is broken up, applied, and committed over several smaller transactions. See ttCacheAutorefIntervalStatsGet and ttCacheAutorefreshXactLimit in the Oracle TimesTen In-Memory Database Reference. Also, see the Oracle In-Memory Database Cache User's Guide.

  • Users can manually initiate a check for missing constraints in AWT cache groups with the ttCacheCheck built-in procedure. See the Oracle In-Memory Database Cache User's Guide and the Oracle TimesTen In-Memory Database Reference.

  • Users can call the ttCacheAutorefreshLogDefrag built-in procedure to compact the trigger log space for a cache autorefresh table. See the Oracle TimesTen In-Memory Database Reference.

  • To prevent an unload operation from becoming a very large transaction, use the new COMMIT EVERY n ROWS clause in the UNLOAD CACHE GROUP statement to specify a commit frequency. See the Oracle TimesTen In-Memory Database SQL Reference and the Oracle In-Memory Database Cache User's Guide.

  • Oracle Database execution errors logged to the awterrs text file can now also be written in XML format. For more details, see Oracle In-Memory Database Cache User's Guide.

  • TimesTen has enhanced dynamic load of cache groups to handle more conditions. For more details, see the Oracle In-Memory Database Cache User's Guide.

  • You can specify the TABLE DEFINITION CHECKING clause as a StoreAttribute for both the CREATE ACTIVE STANDBY PAIR and the ALTER ACTIVE STANDBY PAIR statements. For details, see the Oracle TimesTen In-Memory Database SQL Reference.

1.1.2.4 SQL
  • TimesTen now supports statement level inline optimizer hints. See the Oracle TimesTen In-Memory Database SQL Reference and the Oracle TimesTen In-Memory Database Operations Guide for details.

  • For the WITH clause in the top-level query, you can now specify the set operator UNION, MINUS or INTERSECT. For details, see the Oracle TimesTen In-Memory Database SQL Reference.

  • You can specify the keyword ENABLE as part of the NOT NULL constraint in a column definition in a CREATE TABLE statement. For details, see the Oracle TimesTen In-Memory Database SQL Reference.

  • You can specify more than one subquery in the SET clause of the UPDATE statement. You can also specify a SELECT DISTINCT subquery in the SET clause of the UPDATE statement. For details, see the Oracle TimesTen In-Memory Database SQL Reference.

  • The DISTINCT modifier is now allowed in scalar subqueries.

  • A certain class of assertion errors that can occur during SQL compilation have been restructured from errors that invalidate the database to internal errors that only affect the statement that encountered the problem. These errors use the TT4053: Internal Error message. They are logged in the file database.assert in the same directory as the checkpoint files.

1.1.2.5 Operations
  • You can configure a range for all shared memory keys used by TimesTen with the -shmkeyrange daemon option. For details, see the Oracle TimesTen In-Memory Database Operations Guide.

1.1.3 Tools for Proof of Concepts

  • A new utility, ttImportFromOracle, analyzes the source tables in an Oracle database and generates scripts for importing the tables into a TimesTen database. It recommends space-efficient data types and compression candidates to reduce the memory requirement for storage in the TimesTen database. It also generates an optimized loader script that performs data loading in parallel. See the readme file ttImportFromOracle.pdf in the install_dir/support directory for details.

1.1.4 Bug Fixes

  • In previous releases, TimesTen did not check for disallowed characters in DSN names. In this release, TimesTen checks DSN names for disallowed characters and returns an error if any are found. (BugDB 9454764)

  • This release includes a new SNMP trap, ttRepStateChange, to track replication agent state changes in the case of active standby pairs. (BugDB 11061633)

  • In previous releases, when the replication agent applied changes from a remote node, if it ran into locking errors, it would treat the error as a permanent error and discard the transaction it was applying. This has been fixed to treat locking error as a transient error. (BugDB 13837176)

  • A problem is fixed where repeatedly calling a PL/SQL anonymous block with identical source text but parameters of different sizes could lead to excessive consumption of PL/SQL Shared Memory. (BugDB 14139020)

  • If the PL/SQL shared memory segment was full at connection time, additional memory was leaked. This problem is fixed. (BugDB 14271697)

  • A potential hang was fixed in TTClasses that could occur when an error was thrown during the TTConnectionPool::freeConnection method. (BugDB 14558534)

  • With a bi-directional replication scheme where only one store is receiving updates, transaction log files can build up on the receiving store if the transmitter on that store falls behind. In addition to the buildup of log files you may also see the transmitter thread(s) restarting periodically. The chances of encountering this issue can be reduced by:

    • Ensuring your workload doesn't exceed a rate that is sustainable by replication

    • Increasing the replication timeout parameter for the store

    • Configuring the largest log buffer that you can with the connection attribute LogBufMB

    These configuration changes allow the transmitter thread on the receiver to process the backlog as quickly as possible. (BugDB 14700079)

  • When a log file was deleted under certain conditions, replicated XLA would run into a memory leak and output an error message referencing an incorrect log file. Both the problem that generated the error and the incorrect error message are fixed. (BugDB 14713045)

  • Built-in procedures that take a table name as an input parameter might trigger an assertion when executed. Such built-ins include ttSize, ttOpStatsExport, and ttAgingScheduleNow. This problem is fixed. In this release, in the case of a problem, TimesTen returns an error. (BugDB 14750394)

  • In previous releases, for active standby pairs managed by Oracle Clusterware, in a failover scenario, propagation to Oracle would take a long time or fail after the standby database became the active database. This problem is fixed. (BugDB 14788796 and 14794358)

  • A bug was fixed which could cause a segmentation violation when a TTCmd object was prepared with a SQL statement that referenced a non-existent table or object. In this release, TimesTen returns an error message. (BugDB 15846108)

  • A problem with TTClasses TTConnectionPool class was fixed where, if a warning occurred while connecting to the database (SQL_SUCCESS_WITH_INFO), the connection would be left unusable in the connection pool. (BugDB 15873607)

  • In previous releases, the SYS.REPSTATS table would use more space than necessary, when there were many subscribers in the replication scheme. The problem is fixed. (BugDB 15933219)

  • Error messages encountered by the ttCWAdmin utility are improved in this release. (BugDB 15967128)

  • The performance of very large inserts in a master-master replication scheme is improved in this release. (BugDB 16077275)

  • In previous releases, after a master-master replication scheme was backed up and restored, using the ttBackup and ttRestore utilities, and the replicated pair was rebuilt using the ttRepAdmin -duplicate command, replication of transactions from the recovered master to the cloned master would proceed normally, but replication of transactions from the cloned master back to the original master would fail. This is fixed. (BugDB 16163788)

  • A problem is fixed where a table would appear to have either a corrupt row or index and access to certain rows failed with a segmentation fault. (BugDB 16222279)

  • An error in ttBulkCp error-handling code had the potential of causing a crash. This would happen when a non-ttBulkCp error appeared, for example a space exhausted error from ODBC. This problem is fixed. (BugDB 16239651)

  • After a TRUNCATE TABLE operation was terminated, cleanup and rollback of the operation would hang. This is fixed. (BugDB 16248444)

  • When using a multi-threaded server, the connection information was not properly associated with the client information, resulting in ttXactadmin reporting the wrong client machine for a transaction. This is fixed. (BugDB 16341580)

  • For UNIX systems, a problem is fixed where a client failover thread could crash if there were too many open file descriptors. (BugDB 16388256)

  • The grantCacheAdminPrivileges.sql is a script that is used to grant privileges on the Oracle database for the cache administrator. It granted CREATE ANY TYPE privilege when CREATE TYPE is sufficient. This is fixed. (BugDB 16390772)

  • An outer join query could return incorrect results if its inner table was a derived table with a SET operator and there was a non-join predicate on this derived table. This is fixed. (BugDB 16417289)

  • A problem is fixed where optimizer statistics were recorded incorrectly. (BugDB 16444228)

  • A rollback assertion on a replication subscriber could occur due to a temporary space transient error. This is fixed. (BugDB 16477586)

  • In this release, TimesTen returns error messages instead of assertions within the autorefresh validation code. In addition, the user can turn off autorefresh validation. (BugDB 16522421)

  • A problem has been fixed where a segmentation fault could occur when running a query with a subquery that contained an aliased analytic function column that was referenced in a WHERE clause but was not referenced in the selected columns. (BugDB 16531241)

  • A problem has been fixed where autorefresh cache groups that had more than 67 tables could cause a buffer overflow. (BugDB 16545934 and 16576353)

  • The very first call to setNull(int parameterIndex, Types.NULL) for DATE/TIMESTAMP fields would throw a restricted data type attribute violation. This is fixed. (BugDB 16619476)

  • A problem has been fixed where an assertion failure would occur if a table alias name was used. (BugDB 16628096)

  • In previous releases, the TimesTen startup file set the PATH variable to include the current directory. In this release, the startup script does not set the PATH variable. (BugDB 16684936)

  • In previous releases, when the cache agent stopped because it encountered an Oracle database error, the cache agent might not restart and no error would be thrown. This problem is fixed.(BugDB 16748309)

1.2 Changes for Release 11.2.2.4.5 from Release 11.2.2.4.4

  • A problem has been fixed where log files that were required by XLA were deleted prematurely. (BugDB 16543915)

  • A problem has been fixed where autorefresh cache groups that had more than 67 tables could cause a buffer overflow. (BugDB 16545637)

1.3 Changes for Release 11.2.2.4.4 from Release 11.2.2.4.3

  • A problem has been fixed where a cache group with many tables with long names could run into an assertion failure. (BugDB 16421159)

  • Operations such as cache autorefreshes that involve hash index lookups with deletes could get stuck in an infinite loop. This has been fixed. (BugDB 16436238)

1.4 Changes for Release 11.2.2.4.3 from Release 11.2.2.4.2

  • A problem has been fixed where needed transaction log files could be purged before transaction completion. This would have been observed as TimesTen error 649 “Log file has been purged” or possibly as an assertion from sbLogLRInfoRead. (BugDB 16285968)

1.5 Changes for Release 11.2.2.4.2 from Release 11.2.2.4.1

  • Under certain conditions after a restart of the replication agent, parallel replication would not make progress waiting for a dependent thread to commit. (BugDB 14700913)

  • A problem was fixed that prevented ODP.NET from connecting to TimesTen when using the ODP.NET 11.2.0.3.0 release with TimesTen 11.2.2.4.1. Either the connect or disconnect request would cause a fatal exception. This is fixed in 11.2.2.4.2 and ODP.NET 12.1 is not affected. (BugDB 14822105)

1.6 Changes for Release 11.2.2.4.1 from Release 11.2.2.4.0

  • An assertion failure that could occur with a large query that contained many complex CASE expressions has been fixed. (BugDB 14464140)

  • A problem is fixed where TimesTen would attempt to allocate an unnecessarily large amount of temporary space for hash-based GROUP BY queries, given only basic cardinality estimates. (BugDB 14634954)

  • A problem has been fixed where calls to some C utility library functions failed with TimesTen error 799 "Unable to connect to daemon; check daemon status" under certain conditions. The utility library functions that failed in this way were ttBackup, ttRamGrace, ttRamLoad, ttRamPolicy, ttRamUnload, and ttXactIdRollback. (BugDB 14676269)

  • In previous releases, TimesTen reported the daemon log message "sbLogFilesRemove: log file XXXX does not exist " when TimesTen cleaned up transaction log files as part of the TimesTen checkpoint operation. In this case, some log files that had previously been removed correctly were incorrectly marked for removal again during the checkpoint operation. This issue is fixed. (BugDB 14697667)

  • A problem has been fixed where, under specific conditions, the system appeared to hang as a result of an incorrect range of transaction log files being queued to be cleaned up during transaction log cleanup operations. The problem manifested itself by emitting a large number of the daemon log messages: "sbLogFilesRemove: log file .logXXX does not exist" (BugDB 14763756)

  • A problem has been fixed with TimesTen OCI that could cause a segmentation violation when calling a PL/SQL procedure or anonymous block that contains an OUT or IN/OUT parameter as the last parameter. (BugDB 14764365)

1.7 Changes for Release 11.2.2.4.0 from Release 11.2.2.3.5

Changes in this release include:

1.7.1 New Features

  • This release contains an Index Advisor that can be used to recommend a set of indexes that can improve the performance of a specific workload. For details, see the Oracle TimesTen In-Memory Database Operations Guide and the Oracle TimesTen In-Memory Database Reference.

  • You can now load a TimesTen table with the result of a query executed on an Oracle database. This feature does not require you to create a cache group. For details, see the Oracle TimesTen In-Memory Database Operations Guide and the Oracle TimesTen In-Memory Database Reference.

  • The TimesTen Cache Advisor provides recommendations on how to initially configure a cache schema, to identify porting issues and to estimate the performance improvement of a specific workload. The Cache Advisor is available on Linux x86-64. For details, see the Oracle In-Memory Database Cache User's Guide and the Oracle TimesTen In-Memory Database Reference.

  • This release contains the built-in procedure ttOptCmdCacheInvalidate that allows you to invalidate compiled statements. For details, see the Oracle TimesTen In-Memory Database Reference.

  • In this release, when performing a ttRepAdmin -duplicate operation, you can specify a local or remote IP address for the destination of the duplicate. For details, see the Oracle TimesTen In-Memory Database Reference and the Oracle TimesTen In-Memory Database Replication Guide.

1.7.2 Bug Fixes

  • In previous releases, if during installation you selected a secondary group for group restricted access and if the main TimesTen daemon is started or restarted by the root user, the daemon incorrectly starts with the primary group permission instead of the secondary group permission.

    This problem could manifest itself in at least one of the following known ways, which may prevent the database from being loaded:

    • TimesTen error 836: Cannot create data store shared memory segment, error error_number

    • An assertion failure, resulting in transaction log files being written: (Assertion failed: 0 [logfile.c:/main/21:sbLogFileCreate:780])

    • TimesTen error 906: Cannot change mode on logfile file_name, error error_details

    This problem is corrected. (BugDB 9966040)

  • When the DROP ACTIVE STANDBY PAIR statements was issued and there was no active standby pair replication scheme, TimesTen was returning error message: 8165: Replication schema is inconsistent. Now, TimesTen returns a more descriptive message: Error 8123: An ACTIVE STANDBY PAIR scheme does not exist. (BugDB 12427319)

  • During replication operations, an SNMP trap is triggered when TimesTen error 16082 is encountered, indicating a table could not be updated. During batch update operations, this trap could be generated for every failed operation, causing heavy SNMP traffic. To prevent this, the error and trap messages have been changed to only report the number of failures that occur within a batch update operation. These messages appear in the support log. (BugDB 13241883)

  • These replication daemon log messages that were previously incorrectly classified as errors now appear as warnings:

    • TT16290: Replication transmitters are stopping.

    • TT16293: Replication thread transmitter is exiting (exitLine line_number)

    • TT16999: Transmitter exiting isAwt

    • TT16999: Receiver exiting isAwt (BugDB 13726055)

  • Previously, when TTC_TIMEOUT was set to 1, SQLQueryTimeout was set to 0. Now, when TTC_TIMEOUT is set to 1, SQLQueryTimeout is also set to 1. See the Oracle TimesTen In-Memory Database Reference for discussion of valid values for these attributes. (BugDB 13796704)

  • This release includes enhanced query optimizations for columns that have numeric, date, time or timestamp types and that do not have a range index. This can improve performance for queries that have a range predicate on such columns. To benefit from this enhancement, you must update statistics. (BugDB 13824787)

  • A problem with computing the column name of a complex view has been fixed. (BugDB 13896607) The problem was manifested in these ways:

    • The ttIsql describe command could show the column name as being empty.

    • A JDBC application could receive a column not found exception when attempting to retrieve a column value from a ResultSet using the column name.

    • The ODBC SQLDescribeCol() function could return incorrect data.

  • In previous releases, when the ttCWAdmin -create command failed due to an error in the generated CREATE ACTIVE STANDBY PAIR statement, the cause was incorrectly identified in the ttCWAdmin output and in the message log as an authentication issue. Also, warnings were treated as errors. Now, when the CREATE ACTIVE STANDBY PAIR statement returns a warning, the active standby pair is created. If the statement generates warnings or errors, now they are displayed in both the output of the call and in the ttcw message log. (BugDB 13907153)

  • A problem is fixed where the replication peer failure state (TT_REPLICATION_INVALID), which is triggered by exceeding the replication threshold, was being reset on a database invalidation or unload. As a result, TimesTen issued the warning TT20100 instead of warning TT8025, after the reload. (BugDB 13915440)

  • Prior to this release, a silent install erroneously prompted the user to enter a server name during a client-only install. This problem is fixed. (BugDB 14057512)

  • A problem has been fixed in which propagation of changes to Oracle from a global cache group could not resume after an active standby failover occurred. (BugDB 14075830)

  • When a member of a grid is detached forcibly, all changes that have not been propagated to Oracle are discarded. In previous releases, global cache groups were unloaded. In this release, local AWT cache groups are also unloaded if any of the changes that were not propagated to Oracle belonged to a local AWT cache group. (BugDB 14076317)

  • TimesTen internal bookkeeping is improved to remove unneeded TimesTen objects left behind in an Oracle database once an autorefresh operation was completed. (BugDB 14115412)

  • A problem has been fixed in TimesTen support for Oracle Clusterware where, under certain conditions, the system would fail and trigger a failover when a user ran the ttCWAdmin -beginAlterSchema command and then ran the ttCWAdmin -status command before running ttCWAdmin -endAlterSchema. (BugDB 14217556)

  • A problem was fixed where the execution of a SQL statement would terminate unexpectedly when referencing a view in a derived table clause, if the view definition contained both a derived table and an ORDER BY clause. (BugDB 14127716)

  • When describing a table using the previous TimesTen 11.2.2 releases of ttIsqlCS and connecting to a TimesTen 11.2.1 instance, the describe command would attempt to access a non-existent column NUMCOMPRESS. This has been corrected. (BugDB 14157399)

  • A problem is fixed where attempting to add a subscriber to an existing replication configuration could result in the deadlock error TT6002. (BugDB 14179123)

  • A problem is fixed where a core dump could occur on the TimesTen server when using an automatic client failover configuration with Oracle Clusterware. The problem could occur even when the server was idle. (BugDB 14181234)

  • In rare instances, an assertion failure could invalidate the database when logs were being flushed to disk while concurrent operations were taking place in the database. (BugDB 14220901)

  • In previous releases, creating a temporary LOB outside a transaction would cause TimesTen to create a transaction that would be left open indefinitely. In this release, that transaction is committed when the temporary LOB is freed. (BugDB 14227570)

  • A message with AWTBatchId details (curAwtBatchId, awtBatchIdAtCrCGTime, awtXactsInBatch, awtStmtsInBatch) was being logged as an error although it might not indicate a problem. This message is now logged at the information level in the support log. (BugDB 14253983)

  • If the PL/SQL shared memory segment was full at connection time, additional shared memory was leaked. The problem has been corrected. (BugDB 14275478)

  • A problem has been fixed where ODP.NET 11.2.0.3 clients that connect to the TimesTen 11.2.2.3 server could fail due to an access violation. (BugDB 14331111)

  • A scalar subquery that contained an Oracle style outer join (+) on a derived table could return the wrong results. This has been corrected. (BugDB 14353684)

  • A problem has been fixed where an assertion failure would occur when a wrong data type was used in an INSERT SELECT statement with a UNION clause on a derived table. (BugDB 14369779)

  • When the active host of a TimesTen cluster configuration that used VIPs was rebooted, the standby host correctly became the active, but the original active host did not become the standby. This has been corrected. (BugDB 14372540)

  • The ttBulkCP utility could use too much permanent space during inserts, if it encountered uniqueness constraint violations. This problem is corrected. (BugDB 14373510)

  • A problem has been fixed where an assertion failure could occur in the TimesTen function sbMapIx_t when updating data. (BugDB 14379300)

  • If ttBackup is run when the database is being loaded and undergoing recovery, the user credentials cannot be checked. Previously TimesTen returned an internal "encrypt failed" error. Now TimesTen returns a more meaningful error. (BugDB 14458502)

  • A problem was fixed in the initCacheAdminSchema.sql script where creating an asynchronous writethrough cache group could cause an Oracle constraint violation and return TimesTen error message 5222. You must run the new version of this script to fix the problem. (BugDB 14511714)

  • A problem was fixed where a literal might be internally cast to an incorrect type when a SQL statement compared a column of TT_BIGINT data type with a string literal. (BugDB 14549475)

  • A potential hang was fixed in TTClasses that could occur when an error was thrown during the TTConnectionPool::freeConnection method. (BugDB 14558534)

  • Use of the built-in ttReplicationStatus can lead to lock timeouts in the replication agent. The effect of this is more pronounced when parallel replication is in use. The locking system that ttReplicationStatus uses has been adjusted so that it does not interfere with the replication agent. (BugDB 14582429)

  • Under certain conditions, executing SELECT statements in the PL/SQL package DBMS_SQL could return columns in the wrong order. This has been corrected. (BugDB 14583425)

  • Specifying multiple Oracle Clusterware managed applications for an active standby pair in the cluster.ini file resulted in a ttCWAdmin utility failure and inconsistent TimesTen Oracle Clusterware resources. This problem has been corrected. (BugDB 14621564)

1.8 Changes for Release 11.2.2.3.5 from Release 11.2.2.3.4

  • A problem is fixed where a SELECT operation could result in unnecessary dynamic loads of data from Oracle that already existed in the TimesTen cache group. This problem occurred when the workload included DML operations. (BugDB 14533454)

1.9 Changes for Release 11.2.2.3.4 from Release 11.2.2.3.3

  • A problem is fixed where a SELECT operation could result in multiple dynamic loads of data from Oracle. (BugDB 14499661)

  • A problem is fixed where the statistics for a local dynamic cache group were incorrectly reported in the sys.systemstats table as statistics for a global dynamic cache group. (BugDB 14504836)

1.10 Changes for Release 11.2.2.3.3 from Release 11.2.2.3.2

  • Previously, dynamic loads could be done only for queries with equality conditions on all columns in primary keys or on all columns in unique indexes. Now, dynamic loads will also be done with a mixture of equality or "is null" conditions on all columns in unique indexes provided that at least one equality condition is used.For more details on dynamic loads, see "Dynamically loading a cache group" in the Oracle In-Memory Database Cache User's Guide. (BugDB 14462078)

    For example:

    CREATE DYNAMIC ASYNCHRONOUS WRITETHROUGH CACHE GROUP cg FROM t1(x1 INT PRIMARY KEY, y1 INT, z1 INT);

    CREATE UNIQUE INDEX u1 ON t1(y1, z1);

    The following queries dynamically load data because all columns of the index are qualified with either an IS NULL condition or an equality with a constant or argument, and at least one column is qualified with an equality condition.

    SELECT * FROM t1 WHERE y1 IS NULL and z1=1;

    SELECT * FROM t1 WHERE y1=1 AND z1 IS NULL;

    SELECT * FROM t1 WHERE y1=1 AND z1=1;

    The following query does not dynamically load data because no column of the unique index was qualified with an equality condition:

    SELECT * FROM t1 WHERE y1 IS NULL AND z1 IS NULL;

1.11 Changes for Release 11.2.2.3.2 from Release 11.2.2.3.1

  • A problem has been fixed where an assertion failure could occur when an INSERT statement contained a UNION clause in a derived table or view. (BugDB 14369779)

  • A problem is fixed where a query that contained a left outer join could fail to dynamically load a writethrough cache group. (BugDB 14373623)

1.12 Changes for Release 11.2.2.3.1 from Release 11.2.2.3.0

  • In previous releases, when a DROP ACTIVE STANDBY operation failed, the ttCWAdmin -drop operation exited with 0, which is considered "success." The problem has been fixed so that ttCWAdmin retries the operation and returns a failure exit code when a DROP ACTIVE STANDBY operation fails. (BugDB 14147496)

  • An inconsistency in the temporary space block free list that could cause an assertion has been fixed. (BugDB 14075421)

  • In previous releases, an assertion failure could occur when performing an INSERT, DELETE or TRUNCATE operation on a table while updating column statistics on the same table. In this release, TimesTen returns an error. (BugDB 14159483 and 14198331)

  • A problem has been fixed on MontaVista Linux Carrier Grade Edition 6, where a TimesTen uninstall would reference an awk script in the wrong directory. (BugDB 14173419)

  • Connections that used global temporary tables or PrivateCommands=1 could take 10 seconds or more to disconnect. The efficiency of disconnect in these cases has been dramatically improved. (BugDB 14198260)

  • A problem has been fixed where a core dump could occur on the TimesTen server when using an automatic client failover configuration with Oracle Clusterware. The problem could occur even when the server was idle. (BugDB 14198318)

  • Previously, cache group operations, such as dynamic load, would fail when connecting to Oracle if the user or application passed an empty Oracle password or did not provide a password. When multiple TimesTen sessions concurrently attempted to connect without specifying the Oracle password, it resulted in a performance degradation for subsequent connection attempts. This is related to a new Oracle database 11.2.0.2 behavior, which is described in KM Doc ID 1309738.1. Currently, if a TimesTen user or application tries to connect passing an empty password, TimesTen does not connect and returns an error message indicating to the user that the password is either empty or not provided. (BugDB 14205374)

  • A problem has been fixed where TimesTen could return the wrong results when batch optimization and OR list optimization were applied to the same table scan. (BugDB 14210736)

  • In rare instances, an assertion failure could invalidate the database when logs were being flushed to disk while concurrent operations were taking place in the database. (BugDB 14217041)

  • A problem has been fixed where a deadlock could occur during an ALTER REPLICATION ... ADD SUBSCRIBER operation. (BugDB 14235264)

  • A long running transaction could hang when an asynchronous writethrough cache group encounters a unique constraint violation. (BugDB 14239972)

  • The maximum value for the cacheAWTParallelism connection attribute is now 31. (BugDB 14241071)

  • When processing batch asynchronous writethrough operations, if the first operation fails, it could result in subsequent operations not serializing properly and becoming inoperative in propagating to the Oracle database. Thus, the batch operation appears to hang. (BugDB 14241173)

  • A problem has been fixed where a previous connection's Oracle password would be used if an Oracle password was not specified for the current connection. (BugDB 14257660)

1.13 Changes for Release 11.2.2.3.0 from Release 11.2.2.2.2

Changes in this release include:

1.13.1 New Features

  • This release contains performance improvements to SQL queries typically occurring in business intelligence (BI) applications.

  • Beginning in 11.2.2.3.0, in the Windows 64-bit installer, there are options to install the 32-bit client.

  • The TimesTen ttjdbc6.jar has been certified to work with the Oracle Java 7 runtime environment (JRE).

1.13.2 Bug Fixes

  • A problem has been fixed where TimesTen returns the error message: repfailover.c(168): TT16067: Failed to retrieve next row for command: repfailover. The error message did not print out enough details about the cause of the failure or whether it was safe to continue. The daemon log now contains specific information by the cause of this error. This information is printed immediately after the error message. (BugDB 12994362)

  • TimesTen internal bookkeeping is improved to remove unneeded TimesTen objects left behind in an Oracle database once an autorefresh operation was completed. (BugDB 13443440)

  • A problem causing an assertion failure existed for active standby pairs in which an XLA replicated bookmark did not advance after an application called ttXlaAcknowledge. The problem is fixed. (BugDB 13642933/13644888)

  • A problem has been fixed where an assertion failure could occur when trying to execute a complex query on a view. (BugDB 13842678)

  • A problem has been fixed with queries that included N to M handling with aggregate queries. (BugDB 13903104)

  • A problem has been fixed where an assertion failure could occur in the deadlock detector of the subdaemon when certain combinations of concurrent serializable and read-committed transactions were active. While the problem combinations could occur in various circumstances, they would most likely occur with replication running. (BugDB 13922118)

  • A problem has been fixed where a query on a view that referenced another view could return TimesTen error 2210: Column reference of columnname is ambiguous. (BugDB 13923377)

  • A problem was fixed where an assertion failure could occur when trying to use showplan with a query. (BugDB 13935557)

  • A problem has been fixed where the ttSqlCmdQueryPlan built-in procedure could return a truncated query plan when the full plan should have been returned. (BugDB 13941976)

  • A problem has been fixed where a ttRepAdmin -duplicate operation would fail with TimesTen error 703 or 12116 if the kernel SEMMSL parameter was configured in the range 2155 to 2205. (BugDB 13952486)

  • A shutdown or failure of an underlying RAC instance could cause a process connected to TimesTen IMDB Cache to terminate abnormally. This included the replication agent and the cache agent processes. This problem is fixed. (BugDB 14002438)

  • A problem has been fixed where a memory leak could occur in an asynchronous writethrough cache group with CacheAWTMethod=0 (SQL array execution method). (BugDB 14055189)

  • Operations, such as cache autorefreshes, that involve hash index lookups with deletes could get stuck in an infinite loop. This has been fixed.(BugDB 14074535)

  • The ADMIN_OPTION column was incorrectly defined in the system views SYS.DBA_SYS_PRIVS and SYS.USER_SYS_PRIVS. This problem resulted in the value of the column always being 'NO'. This has been fixed. (BugDB 14088236)

1.14 Changes for Release 11.2.2.2.2 from Release 11.2.2.2.1

Changes in this release include:

1.14.1 New Features

  • For an INSERT...SELECT query, you can now reference the target table in the FROM clause or in a subquery.

1.14.2 Bug Fixes

  • The ttAdmin utility is enhanced to allow users to specify whether a database is automatically reloaded into memory after a failure, when the RAM policy is set to manual. You can specify the -autoreload option when setting RAM policy to allow the database to be automatically reloaded into memory or you can specify the -noautoreload option. By default, TimesTen automatically reloads the database into memory after a failure. (BugDB 10315164)

  • In this release, multiple ttRepAdmin -duplicate operations can progress concurrently from multiple TimesTen databases caching the same Oracle database. This was not possible in previous releases. (BugDB 13449200)

  • In previous releases, any committed deletes on cached tables in a global AWT cache group could not be propagated if the node was not attached; an attach request could not be completed until all committed updates on cached tables are propagated. This has been fixed in this release. During re-attach, after checking with all currently attached nodes that TimesTen can re-attach the failed node, grid enters a state that enables propagation to proceed. (BugDB 13526159)

  • A problem has been fixed that caused CREATE ACTIVE STANDBY PAIR and CREATE REPLICATION operations to take an excessive time to complete. (BugDB 13581877)

  • In previous releases, for a "group restricted" TimesTen instance, some diagnostic files, such as .inval files, had incorrect permissions. This problem is fixed. (BugDB 13582575)

  • In previous releases, a COMMIT after an update in an active standby pair would fail with TimesTen errors 971 and 16080. This release includes additional integrity checks to prevent the problem from occurring. (BugDB 13590358)

  • In release 11.2.2.2.0, updating a unique column with the same value could result in a unique constraint violation. This problem is fixed. (BugDB 13604455)

  • A problem has been fixed in which setting the PLSQL_MEMORY_SIZE connection attribute to a value of 2048 stopped manual RAM loading from working. (BugDB 13632878)

  • In TimesTen release 11.2.2.2.0, a problem existed where automatic parallel replication failed with the TimesTen error 1689: Replication receivers face dependency error. This problem is fixed. (BugDB 13657510)

  • In previous releases, a COMMIT after an update in an active standby pair would fail with TimesTen errors 971 and 16080. This release includes additional integrity checks to prevent the problem from occurring. (BugDB 13744749)

  • A problem has been fixed where an assertion failure could occur when creating a view. This bug was encountered during a ttMigrate restore operation. (BugDB 13780385)

1.15 Changes for Release 11.2.2.2.1 from Release 11.2.2.2.0

  • An assertion failure occurred in the function sbPtIsExp(exp)when compiling complex queries that involved a WITH clause, a derived table and aggregate functions. This problem is fixed. (BugDB 13689995)

  • An assertion failure occurred in the function sbColGetTupNumAndPos while executing a complex query that included inline views and GROUP BY clauses. This problem is fixed. (BugDB 13562164)

  • A problem has been fixed where an assertion failure could occur when preparing a query that contained a TO_CHAR function that had an improperly formatted model string. This has been fixed. The query now returns a syntax error. (BugDB 12964756)

1.16 Changes for Release 11.2.2.2.0 from Release 11.2.2.1.0

Changes in this release include:

1.16.1 New features

  • The new automatic parallel replication allows for the parallel replication and application of transactions changes to the receiving nodes in a replication scheme. See the Oracle TimesTen In-Memory Database Replication Guide for more details.

  • The ttIsql utility now supports autovariables, showcurrenttime as a set/show attribute, the IF command, WHENEVER error. (BugDB13562164)

  • Added support for ODBC SQLCancel.

1.16.2 Behavior changes

  • Passthrough levels other than 0 are not supported with the utilities ttMigrate, ttBulkCp and ttSchema. Now an error is returned if the PassThrough connection attribute is set to a level other than 0.

  • In Release 11.2.2.1.0, we documented the requirement that unique or foreign key constraints on Oracle must have a corresponding TimesTen unique or foreign key constraint. If the constraint cannot be added to TimesTen, then Parallel AWT should not be enabled.

    In Release 11.2.2.2.0, TimesTen checks if there are any cached columns within an AWT table that belong to an Oracle unique index or a unique constraint that don't have a corresponding unique index on TimesTen. If any columns are found when creating a cache group, TimesTen returns a warning, at which time the user can fix this issue. If any columns are found when the replication agent is started, TimesTen returns an error and shuts down the replication agent.

  • The SQLCancel ODBC function can now perform a statement cancel on an hstmt from a different thread. In this case, the SQLCancel issues the cancel request and returns immediately. Previously, SQLCancel would block, waiting for the original SQL operation to complete.

    TimesTen still does not support an asynchronous cancel on an hstmt executed with the SQL_ASYNC_ENABLE flag set.

  • When the ttIsql utility receives the signal SIGINT while running an ODBC statement, ttIsql attempts to interrupt the statement using SQLCancel. Previously ttIsql needed to wait until the statement completed before ttIsql could interrupt the given command. The ttIsql utility no longer exits if it receives two SIGINT signals during an ODBC call.

  • Some mixes of DML and DDL statements in the same transaction while using DDLCommitBehavior=1 are no longer allowed. For example, transactions that update rows in a table and then create an index on that same table, or that update rows in a table and then resize that table's hash index with an ALTER TABLE ... PAGES = n now return an error. The error can be prevented if you do not mix DML and DDL statements in the same transaction.

1.17 Changes for Release 11.2.2.1.0 from Release 11.2.1

Changes in this release include:

1.17.1 New features

  • In-memory columnar compression of tables.

  • Large objects (LOBs), including CLOBs (character LOBs), NCLOBs (national character LOBs), and BLOBs (binary LOBs).

  • Associative arrays, formerly known as index-by tables or PL/SQL tables, are supported as bind parameters in TimesTen PL/SQL, such as from an OCI, Pro*C, or JDBC application.

  • TimesTen now supports some wide-character ("W") versions of ODBC functions. For example, SQLGetConnectOptionW is supported in addition to SQLGetConnectOption. See the Oracle TimesTen In-Memory Database C Developer's Guide for more details.

  • PL/SQL anonymous blocks and procedure or function calls, in addition to SQL statements, are supported in an EXECUTE IMMEDIATE statement or DBMS_SQL procedure or function call.

  • A global query (a query executed on multiple members of an Oracle In-Memory Database Cache grid) can reference more than one table.

  • The ability to determine the current space usage of a table using the ttComputeTabSizes built-in procedure.

  • The maximum number of indexes per table has increased to 500. The previous maximum was 32.

  • You can configure parallel propagation of changes in AWT cache tables to the corresponding Oracle tables.

  • The maximum value of the LogBufMB and LogFileSize connection attributes has increased to 64GB on 64-bit systems.

  • You have additional control over TimesTen application failover behavior when Oracle Clusterware is managing a TimesTen active standby pair. The AppFailureInterval, AppRestartAttempts and AppUptimeThreshold Clusterware attributes are new. See the Oracle TimesTen In-Memory Database Replication Guide for more information.

1.17.1.1 Additional SQL functionality for analytics workloads and complex queries

See Oracle TimesTen In-Memory Database SQL Reference for more information.

  • Analytic functions and clauses:

    • Analytic functions: AVG, SUM, COUNT, MAX, MIN, DENSE_RANK, RANK, ROW_NUMBER, FIRST_VALUE and LAST_VALUE

    • Analytic clauses: OVER PARTITION BY and OVER ORDER BY

  • Multidimensional grouping operators:

    • Grouping clauses: GROUP BY CUBE, GROUP BY ROLLUP, GROUP BY GROUPING SETS

    • Grouping functions: GROUP, GROUPING_ID, GROUP_ID

  • WITH clause, which allows repeated references to a named subquery block

  • Aggregate expressions over DISTINCT expressions

  • General expressions that return a character string in the source or a pattern within the LIKE predicate

  • Ability to order nulls first or last in a sort result (NULLS FIRST or NULLS LAST in the ORDER BY clause)

1.17.1.2 Implicit data type conversion

See Oracle TimesTen In-Memory Database SQL Reference for more information.

  • TimesTen implicitly converts data types in many cases. For example:

    SELECT 1 + '1' FROM dual;
    
1.17.1.3 Support for arithmetic operations on date and time values

See Oracle TimesTen In-Memory Database SQL Reference for more information.

  • TimesTen allows arithmetic operations on date and timestamp expressions. For example:

    SELECT SYSDATE + 1 FROM dual;
    
1.17.1.4 New SQL scalar functions

See Oracle TimesTen In-Memory Database SQL Reference for more information.

  • LOBs: EMPTY_CLOB, EMPTY_BLOB, TO_BLOB, TO_CLOB, TO_LOB, TO_NCLOB

  • National Language Support (NLS) properties: NLS_CHARSET_ID and NLS_CHARSET_NAME

  • Cache grid properties: TTGRIDMEMBERID, TTGRIDNODENAME, TTGRIDUSERASSIGNEDNAME

  • Timestamp arithmetic: TIMESTAMPADD and TIMESTAMPDIFF

  • Other SQL scalar functions: SOUNDEX, REPLACE, MONTHS_BETWEEN, NULLIF

1.17.1.5 New system views

See Oracle TimesTen In-Memory Database System Tables and Views Reference for more information.

  • SYS.ALL_TABLES, SYS.DBA_TABLES, SYS.USER_TABLES

  • SYS.ALL_VIEWS, SYS.DBA_VIEWS, SYS.USER_VIEWS

  • SYS.ALL_TAB_SIZES, SYS.DBA_TAB_SIZES, SYS.USER_TAB_SIZES

1.17.1.6 New built-in procedures

See Oracle TimesTen In-Memory Database Reference for more information.

  • ttComputeTabSizes computes the current size of a table.

1.17.1.7 Utility enhancements

See Oracle TimesTen In-Memory Database Reference for more information.

  • ttStatus has a new option for displaying the status of a single database.

  • ttIsql has new commands to support LOBs, table compression, table size reporting and PL/SQL associative binds.

  • ttsize has been enhanced to report more information.

  • ttVersion has a new option to generate information only about a specified attribute.

1.17.2 Behavior changes

  • PreparedStatement.setBoolean(int parameter, false) sets the column to 0 regardless of the data type. In previous releases, PreparedStatement.setBoolean(int parameter, false) set CHAR, VARCHAR, NCHAR, and NVARCHAR columns to null.

  • When DURABLE COMMITS ON is specified as part of the return services STORE clause for a replication scheme, durable commits are issued when return service blocking is disabled regardless of whether the replication agent is running or stopped. They are also issued for an active standby pair in which the ttRepStateSave built-in procedure has marked the standby database as failed.

  • When creating a cache group, a WHERE clause must be placed on an individual table. In previous releases, the WHERE clause could reference any table within the cache group. In the current release, it can only reference a specific table.

  • The default setting for the DDLReplicationLevel general connection attribute has changed from 1 to 2. See Oracle TimesTen In-Memory Database Reference for more details.

  • The default value for the CacheAWTMethod first connection attribute is changed. 1 (PL/SQL method) is the default now.

  • In this release, WITH is a reserved word.

  • The Connections attribute is changed in this release. The default value is the lesser of 2000 or the number of semaphores specified in the SEMMSL kernel parameter. The value of this attribute specifies only the number of user connections. Previously, the value needed to include the user connections and the connections by the subdaemon, replication agent, etc. In previous releases, TimesTen returned a warning if the number of connections exceeded the value of the Connections attribute. In this release, TimesTen returns an error and the connection fails. See the Oracle TimesTen In-Memory Database Reference for more details.

  • The prefix of daemon log messages for IMDB Cache has changed from ORA to CAC.

  • Hex literals with odd lengths are now prefixed with 0. This rule also applies to bind variables handled by the ttIsql utility. Previously, hex literals with odd lengths were appended with 0.

  • TO_CHAR is used to convert both NUMBER and DATE to CHARACTER according to the specified format. TimesTen returns hash (#) with Oracle type mode (TypeMode=0) if the argument is a NUMBER and it cannot be represented in the specified format. The number of hashes returned depends upon the format length. Previously, an error would be returned in Oracle type mode. This behavior conforms to that of the Oracle Database.

  • When passing a string to a built-in procedure with only whitespace characters, an error is returned. In previous releases, a string with only whitespace characters was treated as 0.

  • In Oracle type mode, subtracting two DATE types now returns the NUMBER data type. Previously, subtracting two dates returned INTERVAL data type and you needed to use EXTRACT to get the number of full days. To ignore fractional days, use TRUNC.

  • In this release ttCacheStop(0) stops the cache agent and waits a maximum of 60 minutes before returning. In previous release, the cache agent would wait forever with ttCacheStop(0).

1.17.3 Bug Fixes

  • When using the ttIsql -connstr command to connect to a DSN with a connection name that contained dashes, the connection would fail. This problem is fixed. (BugDB 12697292)

  • When creating a cache group, a WHERE clause must be placed on an individual table. In previous releases, the WHERE could reference any table within the cache group. In the current release, it can only reference a specific table. (BugDB 9734178)

  • A problem has been fixed where an invalidation would occur when altering a table's index type. (BugDB 10231809)

  • In this release, you can programmatically change the autorefresh timeout value with the ttcacheconfig built-in procedure. (BugDB 11074124)

  • The UNLOAD CACHE GROUP statement now honors the user SQLQueryTimeout setting. (BugDB 11936268)

  • A problem has been fixed where the TimesTen cache agent could drop Oracle user triggers during startup under certain circumstances. (BugDB 12643487)

  • In previous releases, there was a spurious warning message in the daemon log. In this release that warning message is a trace. (BugDB 12913769)

  • JDBC C/S driver leaked memory if the number of parameters in a PreparedStatement or CallableStatement were not an integral multiple of four. This is fixed. (BugDB 12969330)

  • When the owner of a view containing a subquery did not have the ADMIN privilege, the owner was unable to select from the view. This problem has been fixed. (BugDB 10394764)

2 Platforms and configurations

This section includes:

2.1 Platforms and compilers

Platform or operating system C/C++ compiler support JDK support
Linux x86-32 and x86-64:
  • Oracle Linux 4, 5 and 6

  • Red Hat Enterprise Linux 4, 5 and 6

  • SUSE Enterprise Server 10 and 11

  • MontaVista Linux CGE 5.0 and 6.0x

  • Asianux 3.0

TimesTen is not supported with LinuxThreads.

Intel compilers, gcc 4.3 and 4.5 Sun JDK 5.0 and 6.0

JRockit JDK 5.0 and 6.0

IBM JDK 6.0.

NOTE: The IBM Java 6 SDK requires Java SE Version 6 SR9-FP2 or above for both Linux x86 and x86-64

Microsoft Windows x86-32 and x86-64:
  • Windows XP, Windows Vista, Windows Server 2003, Windows Server 2003 Release 2, Windows Server 2008, Windows 7

Visual Studio 2010, 2008 and 2005 for Windows Sun JDK 5.0 and 6.0

JRockit JDK 5.0 and 6.0

Solaris SPARC 64-bit:
  • Oracle Solaris 10 and 11

Sun Studio 11 and 10 for Solaris SPARC Sun JDK 5.0 and 6.0

JRockit JDK 5.0 and 6.0

Solaris x86-64:
  • Oracle Solaris 10 and 11

Sun Studio 11 and 10 for Solaris x86 Sun JDK 5.0 and 6.0
IBM AIX 64-bit:
  • AIX 6.1 and 7.1

IBM Compiler for AIX IBM JDK 5.0 and 6.0
Solaris SPARC 32-bit (client only):
  • Oracle Solaris 10 and 11

Sun Studio 11 and 10 for SPARC Sun JDK 5.0 and 6.0
IBM AIX 32-bit (client only):
  • AIX 6.1 and 7.1

IBM Compiler for AIX 32-bit IBM JDK 5.0 and 6.0

TimesTen is supported in virtual machines provided by Oracle VM.

2.2 Client/Server configurations

A TimesTen client on any supported platform can connect to a TimesTen server on any platform where TimesTen is supported.

For configuration details see "Configuring TimesTen Client and Server" in the Oracle TimesTen In-Memory Database Operations Guide.

2.3 Oracle In-Memory Database Cache

Oracle In-Memory Database Cache (IMDB Cache) enables you to cache Oracle database data in TimesTen. The TimesTen installation includes Oracle Instant Client. The following Oracle server releases are supported with the IMDB Cache option:

  • Oracle Database 10g Release 2 (10.2.0.5.0 or above)

  • Oracle Database 11g Release 1 (11.1.0.7.0 or above)

  • Oracle Database 11g Release 2 (11.2.0.2.0 or above)

2.4 Replication configurations

TimesTen replication is supported only between identical platforms and bit-levels.

Oracle Clusterware 11.2.0.2 is supported with TimesTen active standby pair replication. For more details, see Oracle TimesTen In-Memory Database Replication Guide.

3 Software requirements

For software requirements, refer to Oracle TimesTen In-Memory Database Installation Guide.

4 Deliverables

You should receive the following with your copy of the Oracle TimesTen In-Memory Database:

  • Release Notes. This document (which you are now reading) covers late-breaking information not included in the formal documentation.

  • Oracle TimesTen Media Pack. The media pack includes the Oracle TimesTen libraries and executables, demo programs, utilities and online documentation. The documentation included on the media pack consists of:

    • Oracle TimesTen In-Memory Database Release Notes (Part Number E21630). See the description above.

    • Oracle TimesTen In-Memory Database Installation Guide (Part Number E21632). This guide provides information about installing and upgrading TimesTen.

    • Oracle In-Memory Database Cache Introduction (Part Number E21631). This guide describes the features of Oracle In-Memory Database Cache and provides information to help developers plan an IMDB Cache application.

    • Oracle TimesTen In-Memory Database Operations Guide (Part Number E21633). This guide provides information about configuring TimesTen and using the ttIsql utility to manage a database. It also provides a basic tutorial for TimesTen.

    • Oracle TimesTen In-Memory Database C Developer's Guide (Part Number E21637). This guide describes how to compile and link your C application with Oracle TimesTen and how to set up and work with Oracle TimesTen databases. It covers topics that include error handling, event management and performance tuning. It also provides a reference for C language-specific APIs.

    • Oracle TimesTen In-Memory Database Java Developer's Guide (Part Number E21638). This guide describes how to compile your Java application with Oracle TimesTen and how to set up and work with Oracle TimesTen databases. It covers topics that include error handling, event management and performance tuning. It also provides a reference for Java language-specific APIs.

    • Oracle TimesTen In-Memory Database TTClasses Guide (Part Number E21640). This guide describes the Oracle TimesTen C++ Interface Classes library. The library provides wrappers around the most common ODBC functionality.

    • Oracle TimesTen In-Memory Database PL/SQL Developer's Guide (Part Number E21639). This guide describes and explains how to use PL/SQL in the TimesTen database. It is intended for anyone developing PL/SQL-based applications for the Oracle TimesTen In-Memory Database.

    • Oracle TimesTen In-Memory Database PL/SQL Packages Reference (Part Number E21645). This guide provides a reference to all PL/SQL packages available for use with the TimesTen database. It is intended for anyone developing PL/SQL-based applications for the Oracle TimesTen In-Memory Database.

    • Oracle Data Provider for .NET Oracle TimesTen In-Memory Database Support User's Guide (Part Number E21641). ODP.NET support for Oracle TimesTen In-Memory Database (TimesTen) enables ADO.NET data access from .NET client applications to TimesTen databases. This document covers features specific to ODP.NET support of and use with TimesTen.

    • Oracle TimesTen In-Memory Database Reference (Part Number E21643). This guide provides a reference to all Oracle TimesTen utilities, built-in procedures, attributes and system limits. Also provides a reference to other features of TimesTen.

    • Oracle TimesTen In-Memory Database SQL Reference (Part Number E21642). This guide contains a complete reference to all TimesTen SQL statements, expressions and functions, including TimesTen SQL extensions.

    • Oracle TimesTen In-Memory Database Error Messages and SNMP Traps (Part Number E21646). This guide contains a complete reference to the TimesTen error messages and information about using SNMP traps with TimesTen.

    • Oracle TimesTen In-Memory Database System Tables and Views Reference (Part Number E21644). This document provides a reference for TimesTen system tables and views and replication tables.

    • Oracle TimesTen In-Memory Database Replication Guide (Part Number E21635). This guide provides background information to help you understand how Oracle TimesTen replication works and step-by-step instructions and examples that show how to perform the most commonly needed tasks. It includes information about TimesTen integration with Oracle Clusterware.

    • Oracle In-Memory Database Cache User's Guide (Part Number E21634). This guide provides background information to help you understand how to create and manage Oracle In-Memory Database Cache and cache grid.

    • Oracle TimesTen In-Memory Database Troubleshooting Guide (Part Number E21636). This guide describes how to troubleshoot some of the problems users encounter when using TimesTen.

    • Oracle TimesTen In-Memory Database JDBC Extensions Java API Reference (Part Number E21647) and Oracle TimesTen In-Memory Database JMS/XLA Java API Reference (Part Number E21648). These references describe TimesTen extensions to JDBC classes and interfaces and the TimesTen JMS/XLA package.

    • Oracle Enterprise Manager System Monitoring Plug-in for Oracle TimesTen In-Memory Database Release Notes (Part Number E21650) and Oracle Enterprise Manager System Monitoring Plug-in for Oracle TimesTen In-Memory Database Installation Guide (Part Number E21649). This guide and the release notes document describe the Oracle Enterprise Manager Plug-in for TimesTen.

If any of these items is missing, contact Oracle TimesTen support.

5 Advance notice

This section lists deprecated and removed items.

5.1 Deprecated items in Release 11.2.2.1.0

Using a deprecated item results in a warning.

  • The -repUpgrade option of ttMigrate has been changed to -exactUpgrade to be consistent with the replication STORE clause TABLE DEFINITION CHECKING EXACT. This is the default.

  • The -noRepUpgrade option of ttMigrate has been changed to -relaxedUpgrade to be consistent with the replication STORE clause TABLE DEFINITION CHECKING RELAXED.

  • The -rename option has been removed from the ttMigrate utility.

  • Features for XLA non-persistent mode have been deprecated and removed from the documentation. Use utilities and APIs for persistent XLA only.

  • Support has been removed for TTClasses methods that take a TTStatus object as the last argument and do not return exceptions.

6 Known problems and limitations

This section contains known problems and limitations in these categories:

6.1 New issues in this release

  • There is a problem with computing the column name of a complex view. The problem manifests in two ways:

    • The ttIsql describe command shows the column name is empty.

    • A JDBC program may receive a "column not found" exception when attempting to retrieve a column value from a result set using the column name.

    The workaround is to retrieve the column value by its position.

  • The -localIP and -remoteIP options for the ttRepAdmin utility are documented in the Oracle TimesTen In-Memory Database Reference. These options are not supported in this release.

  • The ODBC SQLExtendedFetch function appears in TimesTen header files. However, TimesTen does not support this function.

6.2 Client/Server

  • In the Windows ODBC Client DSN Setup dialog box, when the Server Name refers to a UNIX host, pressing the Refresh button to get the list of DSNs on that server sometimes fails to obtain the list. Enter a known DSN in the Server DSN field to create the client DSN entry successfully. TimesTen connections from Windows using that client DSN work normally.

  • On UNIX, when using ttlocalhost, a client of one TimesTen instance cannot connect with a server of another TimesTen instance. For example, a 32-bit TimesTen client cannot connect to a 64-bit TimesTen server when using ttlocalhost. The workaround is to use ttShmHost (shared memory IPC) or localhost (127.0.0.1).

  • While using shared memory as IPC, the application may see the error message 24 from the client driver if the application reaches the system-defined, per process file descriptor limit. This may happen during a connect operation to the Client DSN when the shmat system call fails because the application has more open file descriptors than the system-defined per-process file descriptor limit.

6.3 IMDB Cache

  • Global cache group operations are not supported on Windows systems.

  • If there are indexes on the Oracle database that are there to enforce constraints, you must duplicate them on TimesTen. This restriction applies for AWT cache groups when parallel propagation is enabled.

  • In the following scenario:

    • There are multiple AWT cache groups.

    • There are pending DML operations to be applied to be propagated to Oracle for an AWT cache group.

    • The AWT cache group is dropped and then recreated.

    The expected behavior is that the pending DML will not be applied to the Oracle database. A problem exists where the pending DML is applied to Oracle. To work around this problem, do one of the following:

    • Drop all AWT cache groups before any cache group is recreated.

      OR

    • Call the ttRepSubscriberWait build-in procedure against the Oracle database to ensure that all pending DML are applied to Oracle before dropping the cache group.

  • If a foreign key on an Oracle database corresponds to cached tables, the foreign key must have an index on it. If there is no index on the foreign key, TimesTen returns an error at the time of cache group creation. This restriction applies for AWT cache groups when parallel propagation is enabled.

  • If an application performs more than one UNLOAD BY ID operation on a cache group, there is potential for a deadlock with the autorefresh transaction executed by the cache agent. The deadlock occurs only if those same rows are being updated on the Oracle database at the same time.

  • Oracle Server bug 7512227 causes TimesTen autorefresh to miss inserts and updates on the Oracle base table. Autorefresh does not miss deletes. The Oracle Server bug applies to Oracle 10g releases 10.2.0.3 and above but does not occur in Oracle Database 11g. There are two solutions:

    • Set the CURSOR_SHARING Oracle server parameter to EXACT.

    • Install the appropriate Oracle patch for Oracle release 10.2.0.5.

    See My Oracle Support document 793948.1.

  • Caching an Oracle synonym that is owned by a different user results in error 5140: Could not find owner.synonym in Oracle. May not have privileges. The workarounds are:

    • The owner of the synonym can create the cache group.

    • Create a new private synonym that points to the original synonym and then create the cache group. The user who owns the cache group that caches the synonym must match the owner of the synonym. (BugDB 8243193)

  • For IMDB Cache to work correctly, the value returned by the hostname command and the uname -n command (UUCP address) must be the same. If hostname and uname -n return different values, IMDB Cache may report constraint violation failures on Oracle. Alternatively, you can use uname -s to make sure that the Internet and the UUCP addresses are the same. (BugDB 7033084)

  • Nullable foreign keys can result in rows without a corresponding parent row. The rows may become stale and may not be refreshed properly through a manual refresh or autorefresh operation. They may not get removed through unload or aging operations, and they may not be updated on Oracle through a flush statement. (BugDB 5735286)

6.4 Installing and uninstalling TimesTen

  • For databases on Linux systems where PermSize+TempSize+LogBufMB+20MB > 256 GB, you must have Large Pages configured to accommodate the size of the shared segment.

  • On Windows 64-bit systems, you need to compile the QuickStart TTClasses demos before you can use them.

  • TimesTen is not supported with these Oracle Linux 5 kernels: Oracle Linux 5 GA with virtualization option (2.6.18-8.el5xen), Oracle Linux 5 Update 1 with virtualization option (2.6.18-53.el5xen), Oracle Linux 5 Update 2 with virtualization option (2.6.18-92.el5xen).

    TimesTen is supported with these Oracle Linux 5 kernels: Oracle Linux 5 kernel version 2.6.18* without the xen suffix and without the virtualization option, Oracle Linux 5 Update 4 with virtualization option (2.6.18-164.el5xen), Oracle Linux 5 Update 5 with virtualization option (2.6.18-194.el5xen).

    The uname -r Linux command displays the Linux kernel version.

  • If you are installing TimesTen on a new 64-bit Linux system, you may find that it is not enabled for 32-bit applications. Select the Compatibility Arch Support and Compatibility Arch Development Support packages to install architecture specific support for your system.

  • On Windows 64-bit systems, you can do either a 64-bit installation (typical) or a 32-bit installation, but you cannot do both a 64-bit installation and a 32-bit installation of the same release. (You could, however, have a 64-bit installation of the 11.2.2.3.0 release and a 32-bit installation of the 11.2.1.9.0 release, for example.)

  • On Windows systems, you cannot perform a modified or incremental installation. For example, if you originally installed only the Oracle TimesTen Client and later wanted to install the Oracle TimesTen Data Manager, you need to uninstall TimesTen and reinstall all of the components you wish to have on your system.

  • To run TimesTen 32-bit on AIX, you must install the appropriate fix or higher mentioned at:

    http://www-01.ibm.com/support/docview.wss?uid=isg1fixinfo105065
    

    Without this operating system patch, core dumps or other serious problems may occur when running TimesTen.

    The root IBM APAR is: IZ10231: R27 OVERWRITTEN AFTER DLSYM EXECUTION APPLIES TO AIX 5300-06.

    See http://www-01.ibm.com/support/docview.wss?uid=isg1IZ10231.

  • When re-installing TimesTen on UNIX, existing sys.odbc.ini and sys.ttconnect.ini files are optionally saved as sys.odbc.ini.old and sys.ttconnect.ini.old files and new demo files are installed. In this case, you must manually merge any additional DSNs that may have been defined after reinstalling.

6.5 JDBC

  • If a JDBC application running in a time zone that has Daylight Savings Time selects a nonexistent time using ResultSet.getTimestamp(), it gets a time that is an hour behind. For example, in Pacific Standard Time, on the day when the time changes from Standard to Daylight Savings Time, the time between 2:00 a.m. and 2:59 a.m. does not exist. So, if a JDBC application running in Standard Time selects a value of '2002-04-07 02:00:00' using getTimestamp() it gets '2002-04-07 01:00:00'.

  • SQL statements in JDBC applications should contain only characters from the database character set. Unicode characters not in the database character set are converted to replacement characters during parsing of the query. Potential workarounds include:

    • Using AL32UTF8 as the database character set.

    • Parameterizing the statement to avoid characters that are not in the database character set in the query text.

  • If you retrieve the same LOB object back-to-back without an intervening update in a transaction, the JDBC driver returns different Java references. All the references, however, point to the same LOB locator. Freeing any one of the references explicitly by the free() method or implicitly by allowing the reference to be garbage-collected renders all other references invalid. Any LOB operation on those references yields the error: TT1806: INVALID LOB LOCATOR SPECIFIED.

    In the following example, blob1 and blob2 point to the same LOB locator.

    // autocommit off
    ResultSet rs = statement.executeQuery("select blobcol from sometable where
     myindex = myvalue for update");
    rs.next();
    Blob blob1 = rs.getBlob(1);
    blob1.setBytes(1, ...);
     
    // no intervening updates to blob1
    rs = statement.executeQuery("select blobcol from sometable where myindex = 
    myvalue for update");
    
    rs.next();
    
    // blob1 and blob2 will point to the same lob locator
    Blob blob2 = rs.getBlob(1)
    
    blob1.free();   // This will render blob2 unusable
    

    To get around this, free blob1 (blob1.free() ) before selecting the LOB. As a general rule, we highly recommend that applications free LOBs after use.

    A variation of this problem occurs while retrieving LOBS as anonymous objects from ResultSets, CallableStatements and TimesTenPreparedStatements if the anonymous object is garbage collected.

    In the following example, an NCLOB is retrieved from a ResultSet as an anonymous object.

    ResultSet rs = preparedStatement.executeQuery();
    System.out.println(rs.getNClob(4).getSubString(1,(int)rs.getNClob(4).length()) );
     
    The NCLOB may be garbage collected once the inner expression is evaluated 
    rendering the reference to the same NCLOB in the outer expression invalid. To 
    avoid this error, always retrieve lobs as named objects. See revised example 
    below:
     
    NClob nclob = rs.getNClob(4);
    System.out.println(nclob.getSubString(1,(int)nclob.length()) );
    

6.6 XLA and JMS/XLA

See Oracle TimesTen In-Memory Database C Developer's Guide for details about XLA. See Oracle TimesTen In-Memory Database Java Developer's Guide for details about JMS.

  • XLA and JMS/XLA return incorrect information for index types for a CREATE INDEX statement. The value reflected in the flag field of ttXlaCreateIndexTup_t in XLA and the INDEX_TYPE value of CREATE_INDEX in JMS/XLA, always return R, indicating regular indexes, regardless of the actual index type.

  • In TimesTen JMS/XLA, the MapMessage.getString() method currently returns NULL for FLOAT data.

  • This limitation applies to JMS/XLA, ODBC/XLA and TTClasses/XLA. When a modification of a LOB column is committed, XLA does not return the value of the LOB. XLA does have the following information:

    • The LOB has been inserted, updated or deleted.

    • Whether the value of the LOB column is NULL or not NULL.

    • The length of the LOB is zero.

    • The value of the LOB is undefined.

  • TimesTen does not generate an XLA (Transaction Log API) record for CREATE MATERIALIZED VIEW LOG operations.

  • JMS/XLA depends on the Oracle GDK for internationalization support. TimesTen distributions include a version of orai18n.jar in install_dir/lib that JMS/XLA is tested against. JMS/XLA may work with other versions of orai18n.jar but those versions are not supported.

  • To achieve the highest throughput, JMS/XLA applications running on Linux should follow performance guidelines presented in the section entitled "Handling high event rates" in Oracle TimesTen In-Memory Database Java Developer's Guide to work around these issues.

6.7 PL/SQL

  • PLSQL_CODE_TYPE=NATIVE can be specified, but it is implemented as INTERPRETED.

  • JRockit on 32-bit Linux allocates a default heap that is 50 percent of available physical memory up to 1 gigabyte. Users of JRockit on 32-bit platforms may need to choose a value for PLSQL_MEMORY_ADDRESS other than the default (10000000). Consider values such as B0000000, which ensures that the PL/SQL shared memory is not part of the JRockit heap.

  • Using q' (quoting syntax) is not supported.

  • UTL_FILE access is limited to a temporary directory located in install_dir/plsql/utl_file_temp. The instance administrator can grant access to UTL_FILE to specific database users. Users can reference the directory using UTL_FILE if and only if they provide the string 'UTL_FILE_TEMP' for the location parameter string.

6.8 Replication

  • Replication for an altered table can fail if the replication agent is stopped immediately after the ALTER TABLE statement has been issued and the agent has not advanced past the end of the ALTER TABLE transaction. This problem can occur regardless of return service policy. If you need to stop the replication agent after an ALTER TABLE transaction, issue a ttRepSubscriberWait call to ensure that the replication agent restart point has advanced beyond the alter table operation.

  • TimesTen can return error message TT6003 when using master-subscriber two-safe replication and autorefresh cache groups. This can occur, specifically, if the first replicated two-safe transaction has either a LOAD CACHE GROUP or an ALTER CACHE GROUP SET AUTOREFRESH STATE operation on an autorefresh cache group. To work around this problem, either avoid doing a LOAD or ALTER on the first replication transaction or use active standby pair replication.

  • If the first operation in a two-safe user session is an ALTER TABLE operation, the ALTER TABLE is not replicated. The workaround is to do some other operation on the table in the same session before altering the table.

  • Under very rare circumstances, it is possible for a pair of replicated detail tables and their corresponding materialized view to diverge. This divergence can only happen if the materialized view satisfies both of the following conditions:

    • The view definition has two or more predicates.

    • One of the predicates contains an expression that can generate an exception such as numeric overflow, division by zero or string truncation.

    Replicating an update to a detail table can cause divergence if differences in the order of predicate evaluation on the two databases cause a predicate to be evaluated and generate an exception only on the receiving database. The store then rejects the update, resulting in divergence of the detail table and the materialized view. To prevent such divergence, users should avoid replicating materialized views that have predicates that can generate exceptions during expression evaluation. The SQL CAST operator can be used in some cases to avoid arithmetic overflow.

  • Foreign key and uniqueness constraints cannot be checked at the statement level if ttXlaApply is used to implement replication.

6.9 SQL, utilities and procedures

  • When the same column alias name is used in a view definition and a query that accesses the view, TimesTen might incorrectly issue the TT2210: Column reference of XXX is ambiguous error. The workaround is to explicitly assign a different column alias name to the column.

  • Deleting rows from a table that has out-of-line columns and dropping that table in the same transaction results in an assertion failure when using DDLCommitBehavior=1. To work around this problem, add a commit between the DELETE statement and the DROP TABLE statement.

  • The maximum sum of the total number of tables specified in a query and all temporary aggregates needed to handle the query is 32. A temporary aggregate is needed to handle scalar or aggregate subqueries. A query fails with the message Statement that needs more than 31 nesting levels has not been implemented when the sum of tables and temporary aggregates in a query is greater than 32.

  • COUNT DISTINCT with CHAR type uses binary sorting order and binary comparison semantics even when the NLSSORT attribute was set to a value different than binary.

  • When the NLS_SORT session parameter is set to a multilingual sort (for example, FRENCH_M), the LIKE operator may produce incorrect results when the pattern match wild-card symbols are applied to the space character.

  • SQL statements in JDBC applications should contain only characters from the database character set. Unicode characters not in the database character set are converted to replacement characters during parsing of the query. Potential workarounds include:

    • Using AL32UTF8 as the database character set.

    • Parameterizing the statement to avoid characters that are not in the database character set in the query text.

6.10 SQL*Plus

  • TimesTen does not support SQL*Plus connections to TimesTen databases. Use ttIsql.

6.11 TimesTen integration with Oracle Clusterware

  • When you perform one of these actions:

    • Answer the prompt for which host should be designated as the host for the active database.

    • Enter the ttCWAdmin -create command.

    You receive the message:

    "Warning!! Data store on host(s) host list may be destroyed in Order to be duplicated from active after the roll out. Please back up this data store manually if necessary, before executing ttCWAdmin -start".

    If a database with the specified DSN exists on the host for the standby database, the old database will be destroyed and replaced with the database that is created by the ttCWAdmin -create command.

    The warning has no meaning if there is no database with the specified DSN on the standby host.

6.12 TimesTen OCI support

  • TimesTen OCI documentation primarily just documents differences between TimesTen OCI support and Oracle Database OCI support. TimesTen customers rely on the Oracle Database documentation for general information and functionality.

    Please be aware of the following errata related to the OCIDescribeAny() function in the "Describing Schema Metadata" chapter of the Oracle Database 11.2.0.2 OCI programmer's guide:

    1. Under "Parameter Attributes", the documentation lists OCI_ATTR_NUM_PARAMS under attributes of all parameters. OCI_ATTR_NUM_PARAMS is actually an attribute only for list parameters.

    2. The value returned when you get the attribute OCI_ATTR_LIST_COLUMNS from OCI_PTYPE_TABLE or OCI_PTYPE_VIEW is of type OCIParam*. This is correctly documented in Appendix A but incorrectly documented as type void* under "Table or View Parameters" in the "Describing Schema Metadata" chapter.

    3. The documentation mentions attribute OCI_ATTR_LIST_TYPE for list types (OCI_ATTR_PTYPE_LIST). This is incorrect. The attribute is OCI_ATTR_LTYPE.

    4. Under "Schema Attributes", the OCI_ATTR_LISTS_OBJECTS attribute is said to be of type OraText*. The type is actually OCIParam*.

  • If NLS_LANG is set to a value that is not supported by TimesTen, spurious errors such as "Cannot connect" may result.

6.13 TimesTen support for Oracle Pro*C/C++ Precompiler

  • On Windows platforms, the link line for a Pro*C application that uses SQLLIB functions should include both OCI.LIB and ORASQL11.LIB. The correct order is OCI.LIB first, then ORASQL11.LIB. Reversing the order can lead to the SQLLIB functions not working.

  • When compiling a Pro*C/C++ demo, this message may appear: "System default option values taken from: install_dir/ttoracle_home/instantclient_11_2/precomp/admin/pcscfg.cfg." The path name may be incorrect.

6.14 TTClasses

  • The TTCmd::setParamNull() method cannot be used to set NULL LOB data in an Oracle database table using passthrough. Instead, use literals in INSERT or UPDATE statements.

6.15 Upgrading TimesTen

  • The ttMigrate utility cannot migrate foreign key dependencies between objects owned by different users to TimesTen release 11.2.1 and later from release 7.0 and older without a workaround. To work around this problem, first restore the parent tables. Then grant the owner of the child tables the appropriate REFERENCES privileges on its parent tables. Finally, restore the child tables.

  • The ttMigrate utility cannot migrate materialized views to TimesTen release 11.2.1 and later from release 7.0 and older without a workaround. To work around this problem, first restore the detail tables referenced by the materialized view. Then grant the owner of the materialized view SELECT privileges on every detail table. Finally, restore the materialized view.

7 Documentation Accessibility

For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.

Access to Oracle Support

Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.


Oracle TimesTen In-Memory Database Historical Release Notes, Release 11.2.2

Copyright © 2012 Oracle and/or its affiliates. All rights reserved.

This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or decompilation of this software, unless required by law for interoperability, is prohibited.

The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to us in writing.

If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following notice is applicable:

U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technical data delivered to U.S. Government customers are "commercial computer software" or "commercial technical data" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and, to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). Oracle America, Inc., 500 Oracle Parkway, Redwood City, CA 94065.

This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices. UNIX is a registered trademark of The Open Group.

This software or hardware and documentation may provide access to or information on content, products, and services from third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products, or services.

Oracle Open World 2014 Banner

In-Memory Replay Banner