This section summarizes the new features of Oracle TimesTen In-Memory Database Release 18.1 that are documented in this guide. It provides links to more information.
The CREATE PROFILE statement creates a profile, which is a set of limits on database resources. See "CREATE PROFILE" for details.
The ALTER PROFILE statement adds, modifies, or removes a password parameter in a profile. See "ALTER PROFILE" for details.
The DROP PROFILE statement drops a profile. See "DROP PROFILE" for information.
These clauses have been added to the CREATE USER and the ALTER USER statements:
PROFILE
ACCOUNT LOCK and ACCOUNT UNLOCK
PASSWORD EXPIRE
See "CREATE USER" and "ALTER USER" for information on these clauses.
The VSIZE function is a scalar function that returns the number of bytes in the internal representation of an expression. See "VSIZE" for information.
The CURRENT_SCHEMA parameter has been added to the SYS_CONTEXT function. See "SYS_CONTEXT" for more information.
The TO_TIMESTAMP is a datetime function that converts a CHAR or VARCHAR2 data type to a value of TIMESTAMP data type. See "TO_TIMESTAMP" for details.
The accessibility clause has been added to the CREATE FUNCTION, CREATE PROCEDURE, and CREATE PACKAGE statements. See "CREATE FUNCTION" or "CREATE PROCEDURE" or "CREATE PACKAGE" for details.
The ACTION, CLIENT_INFO, and MODULE parameters have been added to the SYS_CONTEXT function. See "SYS_CONTEXT" for more information.
These scalar functions are supported:
ACOS: See "ACOS" for information.
ASIN: See "ASIN" for information.
ATAN: See "ATAN" for information.
ATAN2: See "ATAN2" for information.
COS: See "COS" for information.
COSH: See "COSH" for information.
EXP: See "EXP" for information.
LN: See "LN" for information.
LOG: See "LOG" for information.
SIN: See "SIN" for information.
SINH: See "SINH" for information.
TAN: See "TAN" for information.
TANH: See "TANH" for information.
The syntax for table name in the SELECT statement allows optional parenthesis. This is also true for the SELECT clause of the INSERT...SELECT and CREATE TABLE AS SELECT statements. See "TableSpec" for details.
You can use the PLSQL_SESSION_CACHED_CURSORS clause in the ALTER SESSION statement to specify the number of session cursors to cache. See "ALTER SESSION" for details.
In TimesTen Scaleout, you can specify the TT_DMLCommitOnSuccess hint to enable or disable a commit operation as part of DML execution. See "TT_CommitDMLOnSuccess optimizer hint" for more information. Also see "Using the TT_CommitDMLOnSuccess hint" in the Oracle TimesTen In-Memory Database Scaleout User's Guide.
TimesTen Scaleout enables you to distribute data across instances in the grid in a highly available manner. There are three distribution schemes used for tables to distribute data:
DISTRIBUTE BY HASH
DISTRIBUTE BY REFERENCE
DUPLICATE
See "CREATE TABLE" for more information.
There are considerations when you ALTER a table in TimesTen Scaleout. See "ALTER TABLE" for more information.
The DISTRIBUTE BY HASH clause is supported in the CREATE MATERIALIZED VIEW statement in TimesTen Scaleout. See "CREATE MATERIALIZED VIEW" for more information.
The ALTER SEQUENCE statement and the BATCH clause of the CREATE SEQUENCE statement are supported in TimesTen Scaleout. See "CREATE SEQUENCE" and "ALTER SEQUENCE" for more information.
The TT_GridQueryExecute and TT_PartialResult optimizer hints are supported in TimesTen Scaleout. See "TT_GridQueryExec optimizer hint" and "TT_PartialResult optimizer hint" for more information.
There are ROWID changes for TimesTen Scaleout. See "ROWID pseudocolumn" for more information.
The elementId#, replicaSetId#, and dataspaceId# pseudocolumns are supported in TimesTen Scaleout. See "Pseudocolumns in TimesTen Scaleout".
The elementIdCompute function is supported in TimesTen Scaleout. See "ELEMENTIDCOMPUTE" for more information.
The SQL statements that are supported in TimesTen are summarized in table format. See "Summary of SQL statements supported in TimesTen" for more information.
Bitwise functions are supported. See "Bitwise functions" for more information.
The return result type for the COUNT and SUM (integer data types) aggregate functions have been changed from TT_INTEGER to TT_BIGINT. See "COUNT" and "SUM" for more information.
COLUMNAR and DISTRIBUTE are reserved words. See Chapter 8, "Reserved Words" for more information.