This section summarizes the new features of Oracle TimesTen In-Memory Database 11g Release 2 (11.2.2) that are documented in this guide and provides links to more information.
New system views have been added:
New statistics have been added.
System Tables and Views Reference
11g Release 2 (11.2.2)
E21644-03
September 2012
Oracle TimesTen In-Memory Database System Tables and Views Reference, 11g Release 2 (11.2.2)
E21644-03
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 END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions applicable to the programs. No other rights are granted to the U.S. Government.
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 TimesTen In-Memory Database is a memory-optimized relational database. Deployed in the application tier, Oracle TimesTen In-Memory Database operates on databases that fit entirely in physical memory using standard SQL interfaces. High availability for the in-memory database is provided through real-time transactional replication.
This document is intended for application developers who use and administer TimesTen. It provides a reference for TimesTen system tables, replication tables and system limits.
TimesTen documentation is available on the product distribution media and on the Oracle Technology Network:
http://www.oracle.com/technetwork/products/timesten/documentation/
TimesTen supports multiple platforms. Unless otherwise indicated, the information in this guide applies to all supported platforms. The term Windows refers to all supported Windows platforms and the term UNIX applies to all supported UNIX platforms, including Linux. See "Platforms" in Oracle TimesTen In-Memory Database Release Notes for specific platform versions supported by TimesTen.
|
Note: In TimesTen documentation, the terms "data store" and "database" are equivalent. Both terms refer to the TimesTen database unless otherwise noted. |
This document uses the following text conventions:
| Convention | Meaning |
|---|---|
| boldface | Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary. |
| italic | Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values. |
monospace | Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter. |
italic monospace | Italic monospace type indicates a variable in a code example that you must replace. For example:
Replace |
| [ ] | Square brackets indicate that an item in a command line is optional. |
| { } | Curly braces indicated that you must choose one of the items separated by a vertical bar ( | ) in a command line. |
| | | A vertical bar (or pipe) separates alternative arguments. |
| . . . | An ellipsis (. . .) after an argument indicates that you may use more than one argument on a single command line. |
| % | The percent sign indicates the UNIX shell prompt. |
| # | The number (or pound) sign indicates the UNIX root prompt. |
TimesTen documentation uses these variables to identify path, file and user names:
| Convention | Meaning |
|---|---|
install_dir | The path that represents the directory where the current release of TimesTen is installed. |
TTinstance | The instance name for your specific installation of TimesTen. Each installation of TimesTen must be identified at install time with a unique alphanumeric instance name. This name appears in the install path. |
bits or bb | Two digits, either 32 or 64, that represent either the 32-bit or 64-bit operating system. |
release or rr | The first three parts in a release number, with or without dots. The first three parts of a release number represent a major TimesTen release. For example, 1122 or 11.2.2 represents TimesTen 11g Release 2 (11.2.2). |
jdk_version | Two digits that represent the version number of the major JDK release. Specifically, 14 represent JDK 1.4; 5 represents JDK 5. |
DSN | The data source name. |
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.
TimesTen stores metadata (information about the contents of your database) in system tables in your database.
Your applications can read the system tables, but it cannot update the system tables. If your application defines a table with the same name as a system table, then your application can read a system table by prefixing the system table name with SYS. For example, SELECT * FROM SYS.TABLES selects rows from the TABLES system table.
Information specific to system tables:
Locks acquired by users on system tables may prevent others from defining data or executing the SQLPrepare ODBC function or the Connection.prepareStatement JDBC method.
The last character in name columns is always a space. Therefore, while the column length for name columns is 31, the maximum object name length is 30.
On 64-bit systems, TimesTen system tables declare certain fields as data type TT_BIGINT. When retrieving these columns with an ODBC program, the application must bind them using SQL_C_BINARY. For information about SQL_C_BINARY, see ODBC documentation.
|
Note: Some tables contain columns namedSYSnumber. Because these columns contain values used internally by TimesTen, they are not documented in this chapter. |
Several system tables and views in TimesTen are reserved for internal or future use. These tables are not described in detail in this chapter:
PL/SQL system tables are reserved for internal use. Use the PL/SQL system views instead. PL/SQL system tables in TimesTen are:
If PL/SQL is enabled in your database, there are tables and views created for the operation of the package UTL_RECOMP:
These PL/SQL system views are reserved for internal use:
By default PUBLIC has SELECT privileges on various system tables and views and EXECUTE privileges on various PL/SQL objects. You can see the list of objects by using this query:
SELECT * FROM sys.dba_tab_privs WHERE grantee='PUBLIC';
The ADMIN or SELECT ANY TABLE privilege is required to access other system tables and views.
The ALL_ARGUMENTS view lists the arguments of the procedures and functions that are accessible to the current user.
Related views
SYS.DBA_ARGUMENTS lists the arguments of the procedures and functions that are available in the database. It has the same columns as ALL_ARGUMENTS.
SYS.USER_ARGUMENTS describes the arguments of the procedures and functions that are owned by the current user. This view does not display the OWNER column.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Object owner. |
OBJECT_NAME | VARCHAR2(30) INLINE | Object name. |
PACKAGE_NAME | VARCHAR2(30) INLINE | Package name. |
OBJECT_ID | TT_BIGINT NOT NULL | Object number. |
OVERLOAD | VARCHAR2(12) INLINE | Indicates the nth overloading ordered by its appearance in the source; otherwise, it is NULL. |
SUBPROGRAM_ID | TT_INTEGER | Unique subprogram identifier. |
ARGUMENT_NAME | VARCHAR2(30) INLINE | If the argument is a scalar type, then the argument name is the name of the argument. A null argument name denotes a function return. If the function return or argument is a composite type, this view will have one row for each attribute of the composite type. Attributes are recursively expanded if they are composite.
The meanings of
|
POSITION | TT_INTEGER NOT NULL | If DATA_LEVEL is 0, then this column contains the position of this item in the argument list, or 0 for a function return value.
If |
SEQUENCE | TT_INTEGER NOT NULL | Defines the sequential order of the argument and its attributes. Argument sequence starts at 1. Return type and its recursively expanded (preorder tree walk) attributes come first, and each argument with its recursively expanded (preorder tree walk) attributes follow. |
DATA_LEVEL | TT_INTEGER NOT NULL | Nesting depth of the argument for composite types. |
DATA_TYPE | VARCHAR2(30) INLINE | Data type of the argument. |
DEFAULTED | VARCHAR2(1) INLINE NOT NULL | Specifies whether or not the argument is defaulted. |
DEFAULT_VALUE | VARCHAR2(4194304) NOT INLINE | Reserved for future use. |
DEFAULT_LENGTH | TT_INTEGER | Reserved for future use. |
IN_OUT | VARCHAR2(9) INLINE NOT NULL | Direction of the argument: (IN, OUT, IN OUT). |
DATA_LENGTH | TT_INTEGER | Length of the argument. |
DATA_PRECISION | TT_INTEGER | Length in decimal digits (NUMBER) or binary digits (FLOAT). |
DATA_SCALE | TT_INTEGER | Digits to the right of the decimal point in a number. |
RADIX | TT_INTEGER | Argument radix for a number. |
CHARACTER_SET_NAME | VARCHAR2(16) INLINE | Character set name for the argument. |
TYPE_OWNER | VARCHAR2(30) INLINE | Owner of the type of the argument. |
TYPE_NAME | VARCHAR2(30) INLINE | Name of the type of the argument. If the type is a package local type (declared in a package specification), then the column displays the name of the package. |
TYPE_SUBNAME | VARCHAR2(30) INLINE | Relevant for package local types. Displays the name of the type declared in the package identified in the TYPE_NAME column. |
TYPE_LINK | VARCHAR2(128) INLINE | Relevant for package local types when the package identified in the TYPE_NAME column is a remote package. This column displays the database link used to refer to the remote package.
TimesTen ignores this value because remote packages are not supported. |
PLS_TYPE | VARCHAR2(30) INLINE | For numeric arguments, the name of the PL/SQL type of the argument. NULL, otherwise. |
CHAR_LENGTH | NUMBER | Character limit for string data types. |
CHAR_USED | VARCHAR2(1) INLINE NOT NULL | Indicates whether the byte limit (B) or character limit (C) is official for the string. |
This view returns no rows. The column definitions are the same as the column definitions for the SYS.ALL_COL_PRIVS view in the Oracle Database. See Oracle Database Reference.
Related views
SYS.DBA_COL_PRIVS returns no rows.
SYS.USER_COL_PRIVS returns no rows.
The ALL_DEPENDENCIES view describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user.
Related views
SYS.DBA_DEPENDENCIES describes all dependencies between objects in the database.
SYS.USER_DEPENDENCIES describes dependencies between objects that are owned by the current user.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Object owner. |
NAME | VARCHAR2(30) INLINE | Object name. |
TYPE | VARCHAR2(17) INLINE NOT NULL | Object type. |
REFERENCED_OWNER | VARCHAR2(30) INLINE | Owner of the referenced object. |
REFERENCED_NAME | VARCHAR2(30) INLINE | Name of the referenced object. |
REFERENCED_TYPE | VARCHAR2(17) INLINE NOT NULL | Type of the referenced object. |
REFERENCED_LINK_NAME | VARCHAR2(128) INLINE | Ignored. |
DEPENDENCY_TYPE | VARCHAR2(4) INLINE NOT NULL | Indicates whether the dependency is a REF dependency (REF) or not (HARD). |
The ALL_DIRECTORIES view describes all directories accessible to the current user.
Related views
SYS.DBA_DIRECTORIES describes all directories in the database. It has the same columns as ALL_DIRECTORIES.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Directory owner. |
DIRECTORY_NAME | VARCHAR2(30) INLINE | Directory name. |
DIRECTORY_PATH | VARCHAR2(4000) NOT INLINE | Directory path. |
The ALL_ERRORS describes the current errors on the stored objects accessible to the current user.
Related views
SYS.DBA_ERRORS describes the current errors on all stored objects in the database. It has the same columns as ALL_ERRORS.
SYS.USER_ERRORS describes the current errors on the stored objects that are owned by the current user. This view does not display the OWNER column.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Object owner. |
NAME | VARCHAR2(30) INLINE | Object name. |
TYPE | VARCHAR2(12) INLINE NOT NULL | Object type (such as PROCEDURE, FUNCTION, PACKAGE). |
SEQUENCE | TT_INTEGER NOT NULL | Sequence number (for ordering purposes). |
LINE | TT_INTEGER NOT NULL | Line number at which the error occurred. |
POSITION | TT_INTEGER NOT NULL | Position in line at which the error occurred. |
TEXT | VARCHAR2(4000) NOT INLINE NOT NULL | Text of the error. |
ATTRIBUTE | VARCHAR2(9) INLINE NOT NULL | Indicates whether the error is an error (ERROR) or a warning (WARNING).< /td> |
MESSAGE_NUMBER | TT_INTEGER | Numeric error number (without any prefix). |
The ALL_IDENTIFIERS view displays information about the identifiers in the stored objects accessible to the current user.
Related views
SYS.DBA_IDENTIFIERS displays information about the identifiers in all stored objects in the database. It has the same columns as ALL_IDENTIFIERS.
SYS.USER_IDENTIFIERS describes the identifiers for all stored objects that are owned by the current user. This view does not display the OWNER column.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Identifier owner. |
NAME | VARCHAR2(30) INLINE | Identifier name. |
SIGNATURE | CHAR(32) | Signature of the identifier. |
TYPE | VARCHAR2(18) INLINE NOT NULL | Identifier type. |
OBJECT_NAME | VARCHAR2(30) INLINE | Name of the object where the identifier action occurred. |
OBJECT_TYPE | VARCHAR2(12) INLINE NOT NULL | Type of the object where the identifier action occurred. |
USAGE | VARCHAR2(11) INLINE NOT NULL | Type of the identifier usage (declaration, definition, call, reference, assignment). |
USAGE_ID | TT_INTEGER | Unique key for the identifier usage within the object. |
LINE | TT_INTEGER | Line number of the identifier action. |
COL | TT_INTEGER | Column number of the identifier action. |
USAGE_CONTEXT_ID | TT_INTEGER | Context USAGE_ID of the identifier usage. |
The ALL_OBJECTS view describes all objects in the database that are accessible to the current user.
|
Note: This view does not include synonyms in databases created with a TimesTen release earlier than 11.2.1.4.0. |
Related views
SYS.DBA_OBJECTS describes all objects in the database. It has the same columns as ALL_OBJECTS.
SYS.USER_OBJECTS describes all objects owned by the current user. This view does not display the OWNER column.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Object owner. |
OBJECT_NAME | VARCHAR2(30) INLINE | Object name. |
SUBOBJECT_NAME | VARCHAR2(30) INLINE | Subobject name is ignored. |
OBJECT_ID | TT_BIGINT NOT NULL | Dictionary object number of the object. |
DATA_OBJECT_ID | TT_BIGINT | Is ignored. |
OBJECT_TYPE | VARCHAR2(17) INLINE NOT NULL | Object type (such as PROCEDURE, FUNCTION). |
CREATED | DATE NOT NULL | Timestamp for creation of object. |
LAST_DDL_TIME | DATE NOT NULL | Timestamp for the last modification of the object resulting from a DDL statement. |
TIMESTAMP | VARCHAR2(78) INLINE NOT NULL | Timestamp for the specification of the object (character data). |
STATUS | VARCHAR2(7) INLINE NOT NULL | Status of the object (VALID, INVALID, or N/A). |
TEMPORARY | VARCHAR2(1) INLINE NOT NULL | Indicates whether the object is temporary. The current session can see only data that it placed in this object itself.
The value is always ' |
GENERATED | VARCHAR2(1) INLINE NOT NULL | Indicates whether the name of this object was system generated (Y or N).
The value is always ' |
SECONDARY | VARCHAR2(1) INLINE NOT NULL | Whether there is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y or N).
The value is always ' |
NAMESPACE | TT_INTEGER NOT NULL | Namespace for the object. |
EDITION_NAME | VARCHAR2(30) INLINE | Ignored. |
The ALL_PLSQL_OBJECT_SETTINGS view displays information about the compiler settings for the stored objects accessible to the current user.
Related views
SYS.DBA_PLSQL_OBJECT_SETTINGS displays information about the compiler settings for all stored objects in the database. It has the same columns as ALL_PLSQL_OBJECT_SETTINGS.
SYS.USER_PLSQL_OBJECT_SETTINGS describes compiler settings for all stored objects that are owned by the current user. This view does not display the OWNER column.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Object owner. |
NAME | VARCHAR2(30) INLINE | Object name. |
TYPE | VARCHAR2(12) INLINE NOT NULL | Object type (such as PROCEDURE, FUNCTION). |
PLSQL_OPTIMIZE_LEVEL | NUMBER | Optimize level used to compile the object. |
PLSQL_CODE_TYPE | VARCHAR2(4000) NOT INLINE | Compilation mode for the object. |
PLSQL_DEBUG | VARCHAR2(4000) NOT INLINE | Indicates whether the object was compiled with debug information. |
PLSQL_WARNINGS | VARCHAR2(4000) NOT INLINE | Compiler warning settings that were used to compile the object. |
NLS_LENGTH_SEMANTICS | VARCHAR2(4000) NOT INLINE | NLS length semantics that were used to compile the object. |
PLSQL_CCFLAGS | VARCHAR2(4000) NOT INLINE | Conditional compilation flag settings that were used to compile the object. |
PLSCOPE_SETTINGS | VARCHAR2(4000) NOT INLINE | Controls whether the PL/SQL compiler generates cross-reference information. |
The ALL_PROCEDURES view describes all PL/SQL functions and procedures, along with associated properties, that are accessible to the current user.
Related views
SYS.DBA_PROCEDURES describes all PL/SQL functions and procedures, along with associated properties. It has the same columns as ALL_PROCEDURES.
SYS.USER_PROCEDURES describes all functions and procedures, along with associated properties that are owned by the current user. This view does not display the OWNER column.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Owner of the procedure or function. |
OBJECT_NAME | VARCHAR2(30) INLINE | Name of the object: top-level function, procedure or package name. |
PROCEDURE_NAME | VARCHAR2(30) INLINE | Name of the procedure or function. |
OBJECT_ID | TT_BIGINT NOT NULL | Object number. |
SUBPROGRAM_ID | NUMBER | Unique subprogram identifier. |
OVERLOAD | VARCHAR2(12) INLINE | Overload unique identifier. |
OBJECT_TYPE | VARCHAR2(17) INLINE | Object type. |
AGGREGATE | VARCHAR2(3) INLINE | Indicates if object is an aggregate function (YES or NO).
TimesTen does not support aggregate functions so value is |
PIPELINED | VARCHAR2(3)INLINE | Indicates if object is a pipelined table function (YES or NO).
TimesTen does not support |
IMPLTYPEOWNER | VARCHAR2(30) INLINE | Name of owner of the implementation type, if any. |
IMPLTYPENAME | VARCHAR2(30) INLINE | Name of the implementation type, if any. |
PARALLEL | VARCHAR2(3) INLINE | Indicates whether the procedure or function is parallel-enabled (YES or NO).
TimesTen does not support You can specify the |
INTERFACE | VARCHAR2(3) INLINE | YES, if the procedure or function is a table function implemented using the Oracle Data Cartridge Interface (ODCI); otherwise NO. TimesTen does not support ODCI so value is NO. |
DETERMINISTIC | VARCHAR2(3) INLINE | YES, if the procedure or function is declared to be deterministic; otherwise NO. |
AUTHID | VARCHAR2(12) INLINE NOT NULL | Indicates whether the procedure or function is declared to execute as DEFINER or CURRENT_USER (invoker). |
The ALL_SOURCE view describes the text source of the stored objects accessible to the current user.
Related views
SYS.DBA_SOURCE describes the text source of all stored objects. It has the same columns as ALL_SOURCE.
SYS.USER_SOURCE describes the text source of the stored objects that are owned by the current user. This view does not display the OWNER column.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Object owner. |
NAME | VARCHAR2(30) INLINE | Object name. |
TYPE | VARCHAR2(12) INLINE NOT NULL | Object type (such as PROCEDURE, FUNCTION, PACKAGE). |
LINE | TT_INTEGER NOT NULL | Line number of this line of source. |
TEXT | VARCHAR2(4000) NOT INLINE | Text source of the stored object. |
The ALL_STORED_SETTINGS view describes the persistent parameter settings for stored PL/SQL units for which the current user has execute privileges.
ALL_STORED_SETTINGS is retained for backward compatibility. Use the ALL_PLSQL_OBJECT_SETTINGS view instead.
Related views
SYS.DBA_STORED_SETTINGS describes the persistent parameter settings for stored PL/SQL units for which the current user has execute privileges. It also returns parameter information for all objects in the database.
SYS.USER_STORED_SETTINGS describes the persistent parameter settings for stored PL/SQL units, but only shows information about PL/SQL units owned by the current user.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Name of the database user owning the stored PL/SQL unit. |
OBJECT_NAME | VARCHAR2(30) INLINE | Name of the PL/SQL unit. |
OBJECT_ID | TT_BIGINT NOT NULL | Object number of the PL/SQL unit. |
OBJECT_TYPE | VARCHAR2(12) INLINE NOT NULL | The type of the PL/SQL unit: PROCEDURE,FUNCTION, PACKAGE or PACKAGE BODY. |
PARAM_NAME | VARCHAR2(30) INLINE NOT NULL | The name of the parameter stored persistently with the PL/SQL unit. |
PARAM_VALUE | VARCHAR2(4000) NOT INLINE | The TO_CHAR () representation of the value of the persistently stored parameter. The width of this column is operating system dependent, but it is at least 255. |
The ALL_SYNONYMS view describes the synonyms accessible to the current user. These criteria determine the list of synonyms that ALL_SYNONYMS shows:
All private synonyms owned by the logged-in user, even if the base object is not accessible to the user.
All public synonyms, even if the base object is not accessible to the user.
All private synonyms owned by a different user, where the base object pointed to by the synonym or by nested synonyms is known to be accessible because of a grant to the logged-in user.
The base object can be a table, view, synonym, index, sequence, PL/SQL stored procedure, PL/SQL function, PL/SQL package, materialized view or cache group.
Related views
SYS.DBA_SYNONYMS describes all synonyms in the database.
SYS.USER_SYNONYMS describes the synonyms owned by the current user. This view does not display the OWNER column.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Owner of the synonym. |
SYNONYM_NAME | VARCHAR2(30) INLINE | Name of the synonym. |
TABLE_OWNER | VARCHAR2(30) INLINE | Owner of the object referenced by the synonym, or creator of the referring synonym if the target is a public synonym. |
TABLE_NAME | VARCHAR2(30) INLINE | Name of the object referenced by the synonym. |
DB_LINK | VARCHAR2(128) INLINE | Reserved for future use. The value is always NULL. |
The ALL_TABLES view describes all tables accessible to the current user. The column names and data types are the same as Oracle. TimesTen returns NULL for some columns that are not supported in TimesTen. You should ignore such columns. See the Description column in the Columns table.
Related views
SYS.DBA_TABLES describes all tables in the database.
SYS.USER_TABLES describes all tables in the database that are owned by the current user.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2 (30) INLINE | Owner of the table. |
TABLE_NAME | VARCHAR2 (30) INLINE | Name of the table. |
TABLESPACE_NAME | VARCHAR2 (30) INLINE | Should be ignored. |
CLUSTER_NAME | VARCHAR2 (30) INLINE | Should be ignored. |
IOT_NAME | VARCHAR2 (30) INLINE | Should be ignored. |
STATUS | VARCHAR2 (8) INLINE NOT NULL | If a previous DROP TABLE operation failed, indicates whether the table is unusable (UNUSABLE) or valid (VALID). |
PCT_FREE | NUMBER | Should be ignored. |
PCT_USED | NUMBER | Should be ignored. |
INI_TRANS | NUMBER | Should be ignored. |
MAX_TRANS | NUMBER | Should be ignored. |
INITIAL_EXTENT | NUMBER | Should be ignored. |
NEXT_EXTENT | NUMBER | Should be ignored. |
MIN_EXTENTS | NUMBER | Should be ignored. |
MAX_EXTENTS | NUMBER | Should be ignored. |
PCT_INCREASE | NUMBER | Should be ignored. |
FREELISTS | NUMBER | Should be ignored. |
FREELIST_GROUPS | NUMBER | Should be ignored. |
LOGGING | VARCHAR2 (3) INLINE NOT NULL | If YES, changes to the table are logged. If NO, changes to the table are not logged. |
BACKED_UP | VARCHAR2 (1) INLINE | Should be ignored. |
NUM_ROWS | NUMBER | Number of rows. |
BLOCKS | NUMBER | Should be ignored. |
EMPTY_BLOCKS | NUMBER | Should be ignored. |
AVG_SPACE | NUMBER | Should be ignored. |
CHAIN_CNT | NUMBER | Should be ignored. |
AVG_ROW_LEN | NUMBER | Should be ignored. |
AVG_SPACE_FREELIST_BLOCKS | NUMBER | Should be ignored. |
NUM_FREELIST_BLOCKS | NUMBER | Should be ignored. |
DEGREE | VARCHAR2 (10) INLINE | Should be ignored. |
INSTANCES | VARCHAR2 (10) INLINE | Should be ignored. |
CACHE | VARCHAR2 (5) INLINE | Should be ignored. |
TABLE_LOCK | VARCHAR2 (8) INLINE | Should be ignored. |
SAMPLE_SIZE | NUMBER | Should be ignored. |
LAST_ANALYZED | DATE NOT NULL | Should be ignored. |
PARTITIONED | VARCHAR2 (3) INLINE NOT NULL | Value returned is NO. TimesTen does not support partitioned tables. |
IOT_TYPE | VARCHAR2 (12) INLINE | Should be ignored. |
TEMPORARY | VARCHAR2 (1) INLINE NOT NULL | If Y, temporary table. Otherwise N. |
SECONDARY | VARCHAR2 (1) INLINE NOT NULL | Value returned is N. Should be ignored. |
NESTED | VARCHAR2 (3) INLINE NOT NULL | Value returned is NO. TimesTen does not support nested tables. |
BUFFER_POOL | VARCHAR2 (7) INLINE NOT NULL | Value returned is DEFAULT. Should be ignored. |
FLASH_CACHE | VARCHAR2 (7) INLINE NOT NULL | Value returned is DEFAULT. Should be ignored. |
CELL_FLASH_CACHE | VARCHAR2 (7) INLINENOT NULL | Value returned is DEFAULT. Should be ignored. |
ROW_MOVEMENT | VARCHAR2 (8) INLINENOT NULL | Value returned is DISABLED. Should be ignored. |
GLOBAL_STATS | VARCHAR2 (3) INLINE NOT NULL | Value returned is NO. Should be ignored. |
USER_STATS | VARCHAR2 (3) INLINE | Should be ignored. |
DURATION | VARCHAR2 (15) INLINE | Indicates the duration of a temporary table. If value returned is SYS$SESSION, rows are preserved for the duration of the session. If value returned is SYS$TRANSACTION, rows are deleted after COMMIT. If value returned is NULL, table is not a temporary table. |
SKIP_CORRUPT | VARCHAR2 (8) INLINE NOT NULL | Value returned is DISABLED. Should be ignored. |
MONITORING | VARCHAR2 (3) INLINENOT NULL | Value returned is NO. Should be ignored. |
CLUSTER_OWNER | VARCHAR2 (30) INLINE | Should be ignored. |
DEPENDENCIES | VARCHAR2 (8) INLINE NOT NULL | Value returned is DISABLED. Should be ignored. |
COMPRESSION | VARCHAR2 (8) INLINE NOT NULL | Indicates whether table compression is enabled (ENABLED) or not (DISABLED). |
COMPRESS_FOR | VARCHAR2 (12) INLINE | If compression is enabled, value returned is QUERY HIGH. Otherwise NULL. |
DROPPED | VARCHAR2 (3) INLINE NOT NULL | Value returned is NO. Should be ignored. |
READ_ONLY | VARCHAR2 (3) INLINE | Indicates whether the table is READ-ONLY or not. Value returned is NULL and should be ignored. |
SEGMENT_CREATED | VARCHAR2 (3) INLINE NOT NULL | Indicates whether the table segment is created or not. Value returned is YES. Should be ignored. |
RESULT_CACHE | VARCHAR2(7) INLINENOT NULL | Value returned is DEFAULT. Should be ignored. |
The ALL_TAB_PRIVS view lists the object privileges granted to the current user, the object privileges granted by the current user, the list of object privileges granted for objects owned by the current user and the object privileges granted to PUBLIC.
Related views
SYS.DBA_TAB_PRIVS describes all object grants in the database.
SYS.USER_TAB_PRIVS describes the object grants for which the current user is the object owner, grantor, or grantee.
Columns
| Column name | Type | Description |
|---|---|---|
GRANTOR | VARCHAR2(30) INLINE | Name of the user who granted the privilege. |
GRANTEE | VARCHAR2(30) INLINE | Name of the user who has the privilege. |
TABLE_SCHEMA | VARCHAR2(30) INLINE | Object owner. |
TABLE_NAME | VARCHAR2(30) INLINE | Object name. |
PRIVILEGE | VARCHAR2(40) INLINENOT NULL | Privilege name. |
GRANTABLE | VARCHAR2(3) INLINE NOT NULL | Value is always NO. |
HIERARCHY | VARCHAR2(3) INLINE NOT NULL | Value is always NO. |
The ALL_TAB_SIZES view contains information about the size of tables that are accessible to the current user. This view also includes information on the size of materialized views and cache tables.
Related views
SYS.DBA_TAB_SIZES contains the information about the size of tables and materialized views that are available in the database. It has the same columns as SYS.ALL_TAB_SIZES.
SYS.USER_TAB_SIZES contains the information about the size of tables and materialized views that are owned by the current user. This view does not contain the OWNER column.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Owner of table or materialized view. |
TABLE_NAME | VARCHAR2(30) INLINE | Name of table or materialized view. |
INLINE_ALLOC_BYTES | TT_BIGINT NOT NULL | The amount of bytes allocated for row pages for the table (inline values). |
NUM_USED_ROWS | TT_BIGINT NOT NULL | The number of rows that are active or unlinked (pending deletes or updates). This column has different semantics than column NUMTUPS in SYS.TABLES. For more information on SYS.TABLES, see "SYS.TABLES". |
NUM_FREE_ROWS | TT_BIGINT NOT NULL | The number of rows that can be inserted into the table without additional allocation cost. This does not include the cost of inserted out-of-line values. |
AVG_ROW_LEN | TT_BIGINT | The average amount of bytes used to store a row. This value considers utilization of row pages, out-of-line buffers and system metadata. |
OUT_OF_LINE_BYTES | TT_BIGINT | The sum of the sizes of out-of-line buffers that store varying character values for the table. |
METADATA_BYTES | TT_BIGINT NOT NULL | Size of internal data structures for system usage. Compressed tables contain a dictionary that includes the distinct compressed values. These values are considered part of the metadata. |
TOTAL_BYTES | TT_BIGINT | The sum of INLINE_ALLOC_BYTES, OUT_OF_LINE_BYTES, and METADATA_BYTES. If OUT_OF_LINE_BYTES is NULL then the value of this column is NULL. |
LAST_UPDATED | TT_TIMESTAMP NOT NULL | Time of last update. |
The ALL_USERS view lists all users of the database that are visible to the current user.
Related views
SYS.DBA_USERS describes all users of the database and contains more columns than ALL_USERS.
SYS.USER_USERS describes the current user of the database and contains more columns than ALL_USERS.
Columns
| Column name | Type | Description |
|---|---|---|
USERNAME | VARCHAR2(30) INLINE | Name of the user. |
USER_ID | TT_INTEGER NOT NULL | ID number of the user. |
CREATED | TT_TIMESTAMP NOT NULL | Date the user was created. |
The SYS.ALL_VIEWS view describes all views accessible to the current user. The column names and data types are the same as Oracle. TimesTen returns NULL for some columns that are not supported in TimesTen. You should ignore such columns. See the Description column in the Columns table.
Related views
SYS.DBA_VIEWS describes all views in the database.
SYS.USER_VIEWS describes all views in the database that are owned by the current user.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2 (30) INLINE | Owner of the view. |
VIEW_NAME | VARCHAR2 (30) INLINE | Name of the view. |
TEXT_LENGTH | NUMBER | Length of the view text. |
TEXT | VARCHAR2 (409600) NOT INLINE | View text. |
TYPE_TEXT_LENGTH | NUMBER | Should be ignored. |
TYPE_TEXT | VARCHAR2 (4000) NOT INLINE | Should be ignored. |
OID_TEXT_LENGTH | NUMBER | Should be ignored. |
OID_TEXT | VARCHAR2 (4000) NOT INLINE | Should be ignored. |
VIEW_TYPE_OWNER | VARCHAR2 (30) INLINE | Should be ignored. |
VIEW_TYPE | VARCHAR2 (30) INLINE | Should be ignored. |
SUPERVIEW_NAME | VARCHAR2 (30) INLINE | Should be ignored. |
EDITIONING_VIEW | VARCHAR2 (1) INLINE NOT NULL | Value returned is N. Should be ignored. |
READ_ONLY | VARCHAR2 (1) INLINE NOT NULL | Value returned is Y. Should be ignored. |
The CACHE_GROUP table describes the definition of a TimesTen cache.
Columns
| Column name | Type | Description |
|---|---|---|
CGNAME | TT_CHAR(31) NOT NULL | Group name. |
CGOWNER | TT_CHAR(31) NOT NULL | Group owner. |
CGID | TT_INTEGER NOT NULL for 32-bit systems
| ID of this cache group. |
ROOT | TT_INTEGER NOT NULL for 32-bit systems
| Unique identifier for cache group's root table. |
SOURCE | TT_CHAR(8) NOT NULL | Data source for caching. The only legal value is 'ORACLE'. |
CGDURATION | TT_INTEGER NOT NULL | Reserved for internal use. |
TBLCNT | TT_SMALLINT NOT NULL | Number of tables in cache group. |
REFRESH_MODE | TT_CHAR(1) NOT NULL | The current autorefresh mode.
|
REFRESH_STATE | TT_CHAR(1) NOT NULL | The current autorefresh mode.
' ' ' |
REFRESH_INTERVAL | TT_BIGINT NOT NULL | Autorefresh interval in milliseconds. |
CGATTRIBUTES | BINARY(4) NOT NULL | Bits 0-7 are for cache group types.
Bits 8-15 are for autoload options. Bit 0: 1 - Bit 1: 1 - Bit 2: 1 - Bit 3: 1 - Bit 8: 1 - Autoload on create (Always 1 for Bit 9: 1 - Dynamic cache group |
REFRESH_WITH_LIMIT | TT_INTEGER NOT NULL | The maximum number of autorefresh change log records kept in the trigger log table in the Oracle database. A larger value causes the autorefresh to use more space in the Oracle database, while it prevents the truncation of logs that are not autorefreshed to TimesTen yet, and therefore reduces the possible fallback to full refresh.
The field is used only by incremental autorefresh |
CVGRIDID | TT_INTEGER NOT NULL | Unique grid ID among grids whose members contain global AWT cache groups. |
GRIDINFO | VARBINARY(409600) NOT INLINE | Reserved for internal use. |
ORATOP | TT_VARCHAR(409600) NOT INLINE | Reserved for future use. |
ORAPROXY | TT_VARCHAR(409600) NOT INLINE | Reserved for future use. |
ORABASE | TT_VARCHAR(409600) NOT INLINE | Reserved for future use. |
TTALIAS | TT_VARCHAR(409600) NOT INLINE | Reserved for future use. |
The COLUMNS table describes every column in every table in the database, including the name of the column, the type of the column and whether the column is nullable.
Columns
| Column name | Type | Description |
|---|---|---|
ID | TT_INTEGER NOT NULL for 32-bit systems
| Matches SYS.TABLES.TBLID of the table that owns the column. |
COLNUM | TT_SMALLINT NOT NULL | Ordinal number of the column as specified when the table is created or subsequently altered. |
COLNAME | TT_CHAR(31) NOT NULL | Column name. |
COLOPTIONS | BINARY(1) NOT NULL | Column specification flags:
0x01 - column is in a primary key. 0x02 - column value is varying-length ( 0x04 - column value can be 0x08 - column values are unique. |
COLTYPE | TT_TINYINT NOT NULL | Data type of column1 TT_SMALLINT2 TT_INTEGER3 BINARY_FLOAT4 BINARY_DOUBLE5 TT_CHAR6 TT_VARCHAR7 BINARY8 VARBINARY11 TT_DECIMAL12 TT_NCHAR13 TT_NVARCHAR14 TT_DATE15 TIME16 TT_TIMESTAMP20 TT_TINYINT21 TT_BIGINT22 TT_VARCHAR (inline)23 VARBINARY (inline)24 TT_NVARCHAR (inline)25 NUMBER26 CHAR27 VARCHAR228 NCHAR29 NVARCHAR230 DATE31 TIMESTAMP32 VARCHAR2 (inline)33 NVARCHAR2 (inline)34 ROWID36 CLOB37 NCLOB38 BLOB |
TYPE_ATTR | TT_INTEGER NOT NULL | Reserved for internal use. |
COLLEN | TT_INTEGER NOT NULL for 32-bit systems
| Length of the column (maximum length for varying-length columns). |
INLINELEN | TT_INTEGER NOT NULL for 32-bit systems
| Identifies how many bytes a given column contributes to the inline width of a row. |
REPUSERID | TT_INTEGER NOT NULL | User-defined identifier for column (set with ttSetUserColumnID built-in procedure). |
DEFAULTVALSTR | TT_VARCHAR(409600) NOT INLINE | The default column value. |
CHAR_USED | TT_CHAR(1) | Indicates the semantics for the column:
' '
|
The COL_STATS table stores the statistics for table columns in the database. Statistics include the number of unique values, number of nulls, number of rows and other information regarding the distribution of column values. No values are present if statistics have not been computed.
Columns
| Column name | Type | Description |
|---|---|---|
TBLID | TT_INTEGER NOT NULL for 32-bit systems
| TimesTen table identifier. |
COLNUM | TT_SMALLINT NOT NULL | Ordinal number of column in table (starting at 1). |
INFO | VARBINARY(4194304) NOT INLINE NOT NULL | Contains a binary representative of the column value distribution information. See "ttOptUpdateStats" in Oracle TimesTen In-Memory Database Reference for an explanation of the distribution information stored in this column. A text representation of this information can be retrieved using the ttOptGetColStats built-in procedure. |
DBA_ARGUMENTS lists the arguments of the procedures and functions that are available in the database. It has the same columns as SYS.ALL_ARGUMENTS.
Related views
This view returns no rows. The column definitions are the same as the column definitions for the SYS.DBA_COL_PRIVS view in the Oracle Database. See Oracle Database Reference.
Required privileges
ADMIN
Related views
SYS.ALL_COL_PRIVS returns no rows.
SYS.USER_COL_PRIVS returns no rows.
DBA_DEPENDENCIES describes all dependencies between objects in the database. See "SYS.ALL_DEPENDENCIES" for column descriptions.
Related views
DBA_DIRECTORIES describes all directories in the database. It has the same columns as SYS.ALL_DIRECTORIES.
Related views
DBA_ERRORS describes the current errors on all stored objects in the database. It has the same columns as SYS.ALL_ERRORS.
Related views
DBA_IDENTIFIERS displays information about the identifiers in all stored objects in the database. It has the same columns as SYS.ALL_IDENTIFIERS.
Related views
DBA_OBJECTS describes all objects in the database. It has the same columns as SYS.ALL_OBJECTS.
Related views
The DBA_OBJECT_SIZE view describes the size, in bytes, of PL/SQL objects.
Related views
SYS.USER_OBJECT_SIZE does not display the OWNER column.
Columns
| Column name | Type | Description |
|---|---|---|
OWNER | VARCHAR2(30) INLINE | Object owner. |
NAME | VARCHAR2(30) INLINE | Object name. |
TYPE | VARCHAR2(12) INLINE NOT NULL | Object type (such as PROCEDURE, FUNCTION, PACKAGE). |
SOURCE_SIZE | NUMBER | Size of the source in bytes. Must be in memory during compilation or dynamic recompilation. |
PARSED_SIZE | NUMBER | Size of the parsed form of the object, in bytes. Must be in memory when an object is being compiled that references this object. |
CODE_SIZE | NUMBER NOT NULL | Code size, in bytes. Must be in memory when this object is executing. |
ERROR_SIZE | NUMBER NOT NULL | Size of error messages, in bytes. Must be in memory during the compilation of the object when there are compilation errors. |
DBA_PLSQL_OBJECT_SETTINGS displays information about the compiler settings for all stored objects in the database. It has the same columns as SYS.ALL_PLSQL_OBJECT_SETTINGS.
Related views
DBA_PROCEDURES all PL/SQL functions and procedures, along with associated properties. It has the same columns as SYS.ALL_PROCEDURES.
Related views
DBA_SOURCE describes the text source of all stored objects. It has the same columns as SYS.ALL_SOURCE.
Related views
DBA_STORED_SETTINGS describes the persistent parameter settings for stored PL/SQL units for which the current user has execute privileges. It also returns parameter information for all objects in the database. It has the same columns as SYS.ALL_STORED_SETTINGS.
Related views
The DBA_SYNONYMS view describes all synonyms in the database. It has the same columns as SYS.ALL_SYNONYMS.
Related views
The DBA_SYS_PRIVS view lists the system privileges granted to all users and to PUBLIC.
Required privileges
ADMIN
Related views
SYS.USER_SYS_PRIVS lists system privileges granted to the current user.
Columns
| Column name | Type | Description. |
|---|---|---|
GRANTEE | VARCHAR2(30) INLINE | Name of the user with the privilege. |
PRIVILEGE | VARCHAR2(40) INLINE NOT NULL | Privilege name. |
ADMIN_OPTION | VARCHAR2(3) INLINE NOT NULL | Indicates whether the user can grant the privilege. Possible values are YES and NO.
The value is |
The SYS.DBA_TABLES view describes all tables in the database. See "SYS.ALL_TABLES" for column descriptions.
Related views
The DBA_TAB_PRIVS view lists the object privileges granted to all users and to PUBLIC.
Related views
Required privileges
ADMIN
Columns
| Column name | Type | Description |
|---|---|---|
GRANTEE | VARCHAR2(30) INLINE | Name of the user with the privilege. |
OWNER | VARCHAR2(30) INLINE | Object owner. |
TABLE_NAME | VARCHAR2(30) INLINE | Object name. |
GRANTOR | VARCHAR2(30) INLINE | Name of the user who granted the privilege. |
PRIVILEGE | VARCHAR2(40) INLINE NOT NULL | Privilege name. |
GRANTABLE | VARCHAR2(3) INLINE NOT NULL | Value is always NO. |
HIERARCHY | VARCHAR2(3) INLINE NOT NULL | Value is always NO. |
The DBA_TAB_SIZES view contains information about the size of tables that are available in the database. Requires ADMIN privileges. It has the same columns as SYS.ALL_TAB_SIZES.
Related views
The DBA_USERS view describes all users of the database.
Related views
Columns
| Column name | Type | Description. |
|---|---|---|
USERNAME | VARCHAR2(30) INLINE | Name of the user. |
USER_ID | TT_INTEGER NOT NULL | ID number of the user. |
PASSWORD | VARCHAR2(30) INLINE | Value is NULL. |
ACCOUNT_STATUS | VARCHAR2(32) INLINE NOT NULL | Value is OPEN. |
LOCK_DATE | TT_TIMESTAMP | Value is NULL. |
EXPIRY_DATE | TT_TIMESTAMP | Value is NULL. |
DEFAULT_TABLESPACE | VARCHAR2(30) INLINE NOT NULL | Value is USERS. |
TEMPORARY_TABLESPACE | VARCHAR2(30) INLINE NOT NULL | Value is TEMP. |
CREATED | TT_TIMESTAMP NOT NULL | Date when the user was created. |
INITIAL_RSRC_CONSUMER_GROUP | VARCHAR2(30) INLINE | Value is NULL. |
EXTERNAL_NAME | VARCHAR2(4000) NOT INLINE | Value is NULL. |
PASSWORD_VERSIONS | VARCHAR2(8) INLINE | Value is NULL. |
EDITIONS_ENABLED | VARCHAR2(1) INLINE | Value is NULL. |
The SYS.DBA_VIEWS view describes all views in the database. See "SYS.ALL_VIEWS" for column descriptions.
Related views
The DUAL table can be used in a SELECT statement that references no other tables, but needs to return at least one row. Selecting from the DUAL table is useful for computing a constant expression with the SELECT statement. Because DUAL has only one row, the constant is returned only once.
Columns
| Column name | Type | Description |
|---|---|---|
DUMMY | TT_VARCHAR(1) NOT INLINE NOT NULL | 'X' |
The INDEXES table stores information about the indexes in the database, including the name, the type (range, bitmap or hash), the index key and whether the index is unique.
Columns
| Column name | Type | Description |
|---|---|---|
IXNAME | TT_CHAR(31) NOT NULL | Index name. |
IXOWNER | TT_CHAR(31) NOT NULL | Name of index owner. |
IXID | TT_INTEGER NOT NULL for 32-bit systems
| TimesTen identifier of index. |
TBLID | TT_INTEGER NOT NULL for 32-bit systems
| TimesTen identifier of indexed table. |
IXTYPE | TT_INTEGER NOT NULL | Index type:
0 - hash index 1 - range index (internal) 2 - bitmap index 3 - range index (User created indexes) |
ISUNIQUE | BINARY(1) NOT NULL | Uniqueness:
0 - nonunique index. 1 - unique index. |
ISPRIMARY | BINARY(1) NOT NULL | Primary key:
0 - not a primary key for table. 1 - primary key for table. |
USETMPHEAP | TT_SMALLINT NOT NULL | Reserved for internal use. |
KEYCNT | TT_SMALLINT NOT NULL | Number of columns in the index key. |
KEYCOLS | BINARY(32) NOT NULL | Array of 2-byte integer column numbers of index key, mapped to binary. |
PAGESPARAM | TT_INTEGER NOT NULL for 32-bit systems
| Number of pages specified for hash index. |
NLSSORTID | TT_INTEGER NOT NULL | For internal use only. |
NLSSORTPARM | VARBINARY(1000) NOT INLINE | For internal use only. |
NLSSORTSTR | TT_VARCHAR(200) NOT INLINE | For internal use only. |
NLSSORTBUFSIZE | TT_SMALLINT | For internal use only. |
NLSSORTMAXSIZE | TT_SMALLINT | For internal use only. |
HAKANFACTOR | TT_INTEGER NOT NULL | For internal use only. |
The MONITOR table stores information about system performance. It contains a single row with statistics about certain events. For many columns, statistics are gathered starting from the time the database is loaded into memory and statistics are cleared when the database is unloaded from memory. With a ramPolicy of manual or always, the database remains in memory when there are no application connections.
For some columns, statistics are gathered as needed. TimesTen does not gather statistics from the time of the first connection for these columns:
PERM_ALLOCATED_SIZE
PERM_IN_USE_SIZE
TEMP_ALLOCATED_SIZE
LAST_LOG_FILE
REPHOLD_LOG_FILE
REPHOLD_LOG_OFF
FIRST_LOG_FILE
CHECKPOINT_BYTES_WRITTEN
For most columns, the MONITOR table is reset whenever there are no connections to the database. TimesTen does not reset the values of the following columns, even when there are no connections to the database:
PERM_ALLOCATED_SIZE
PERM_IN_USE_SIZE
TEMP_ALLOCATED_SIZE
LAST_LOG_FILE
REPHOLD_LOG_FILE
REPHOLD_LOG_OFF
FIRST_LOG_FILE
TimesTen frequently updates information in the MONITOR table. To prevent these updates from slowing down the system, they are not protected by latches. Hence values in the MONITOR table are not absolutely accurate. They can be used as a reliable indication of activities in the system.
|
Note: See theSYS.SYSTEMSTATS table if the desired statistic is not in the SYS.MONITOR table. There are statistics that exist in both the SYS.MONITOR table and in the SYS.SYSTEMSTATS table. |
Columns
See also
The PLAN table contains the execution plan that the TimesTen query optimizer prepares after an application calls ttOptSetFlag. See "Generating a query plan" and "Modifying plan generation" in Oracle TimesTen In-Memory Database Operations Guide.
The execution plan includes the operation performed at each step and the table or index that it references.
Columns
| Column name | Type | Description |
|---|---|---|
STEP | TT_INTEGER NOT NULL | Ordinal number of the operation, starting at 1. |
LEVEL | TT_INTEGER NOT NULL | Level of this operation in the plan tree. |
OPERATION | TT_CHAR(31) NOT NULL | Type of operation, one of:
unsorted list (requires extra temporary space)
|
TBLNAME | TT_CHAR(31) | Name of table scanned at this step.
Column is |
IXNAME | TT_CHAR(31) | Name of index used at this step.
Range index names may have a " Column is |
PRED | TT_VARCHAR(1024) NOT INLINE | Predicate applied during table or index scan or join. Column is NULL if no predicate applies. |
OTHERPRED | TT_VARCHAR(1024) NOT INLINE | Predicate applied after table or index scan or join. Column is NULL if no predicate applies. |
The PUBLIC_DEPENDENCY view describes dependencies to and from objects, by object number (OBJECT_ID).
Columns
| Column name | Type | Description |
|---|---|---|
OBJECT_ID | TT_BIGINT NOT NULL | Object number. |
REFERENCED_OBJECT_ID | TT_BIGINT NOT NULL | Referenced object (the parent object). |
The SEQUENCES table contains all the information about sequences. Data from the system table is restored to the new database during a CREATE SEQUENCE statement.
Columns
| Column name | Type | Description |
|---|---|---|
NAME | TT_CHAR(31) NOT NULL | Sequence name. |
OWNER | TT_CHAR(31) NOT NULL | Sequence owner. |
MINVAL | TT_BIGINT NOT NULL | Minimum value. |
MAXVAL | TT_BIGINT NOT NULL | Maximum value. |
INCREMENT | TT_BIGINT NOT NULL | Increment value. |
CACHESIZE | TT_BIGINT NOT NULL | Number of sequence number to be cached. For internal TimesTen use. |
LASTNUMBER | TT_BIGINT NOT NULL | Last number incremented. |
SEQID | TT_INTEGER NOT NULL on 32-bit systems
| ID of the sequence row. |
CYCLE | BINARY(1) NOT NULL | Flag to indicate to wrap around value. |
IS_REPLICATED | BINARY(1) NOT NULL | 0 – Sequences are not being replicated
1 – Sequences are being replicated |
REPACCESS | TT_CHAR(1) NOT NULL | Flag to indicate that sequences cannot be incremented on subscriber-only databases. |
This view returns no rows. The column definitions are the same as the column definitions for the SYS.SESSION_ROLES view in the Oracle Database. See Oracle Database Reference.
The SYSTEM_PRIVILEGE_MAP table describes privilege type codes. This table can be used to map privilege type numbers to type names.
Columns
| Column name | Type | Description |
|---|---|---|
PRIVILEGE | TT_INTEGER NOT NULL | Numeric privilege type code. |
NAME | VARCHAR2(40) INLINE NOT NULL | Name of the type of privilege. |
PROPERTY | TT_INTEGER NOT NULL | Property flag of the privilege. |
The SYSTEMSTATS table stores systemwide monitoring statistics.
Columns
| Column name | Type | Description |
|---|---|---|
NAME | TT_CHAR(64) NOT NULL | Name of statistic. |
VALUE | TT_BIGINT NOT NULL | Value of statistic. |
Rows
This section contains tables with names and definitions of the statistics reported in the SYSTEMSTATS table. The statistics are subject to change across software releases.
Table 1-1 Asynchronous writethrough (AWT) cache group statistics
| Name | Description |
|---|---|
|
|
Number of TimesTen transactions propagated to the Oracle database. |
|
|
Number of rows inserted into the Oracle database in SQL mode ( |
|
|
Number of rows updated on the Oracle database in SQL mode. |
|
|
Number of rows deleted on the Oracle database in SQL mode ( |
|
|
Number of insert batches sent to the Oracle database in SQL mode ( |
|
|
Number of update batches sent to the Oracle database in SQL mode ( |
|
|
Number of delete batches sent to the Oracle database in SQL mode ( |
|
|
Number of bytes sent to the Oracle database in SQL mode ( |
|
|
Number of batches sent to the Oracle database in SQL mode ( |
|
|
Number of rows inserted on the Oracle database in PL/SQL mode ( |
|
|
Number of rows updated on the Oracle database in PL/SQL mode ( |
|
|
Number of rows deleted on the Oracle database in PL/SQL mode ( |
|
|
Number of bytes sent to the Oracle database in PL/SQL mode ( |
|
|
Number of PL/SQL block batches sent to the Oracle database ( |
|
|
Number of calls made to the Oracle database for AWT writes. |
|
|
Number of AWT transactions committed on the Oracle database. |
|
|
Number of rollbacks on the Oracle database because of errors. |
|
|
Number of times AWT transactions are retried on the Oracle database in case of an error. |
Table 1-2 Autorefresh cache group statistics
| Name | Description |
|---|---|
|
|
Number of rows inserted in TimesTen during autorefresh from the Oracle database. |
|
|
Number of rows updated in TimesTen during autorefresh from the Oracle database. |
|
|
Number of rows deleted in TimesTen during autorefresh from the Oracle database. |
|
|
Number of autorefresh cycles completed successfully on TimesTen. |
|
|
Number of autorefresh cycles that failed because of errors. |
|
|
Number of full refreshes triggered during autorefresh operations. |
Table 1-3 Cache group flush statistics
| Name | Description |
|---|---|
|
|
Number of flush cache group executions. |
|
|
Number of rows flushed to the Oracle database. |
|
|
Number of bytes flushed to the Oracle database. |
Table 1-4 Synchronous writethrough (SWT) cache group statistics
| Name | Description |
|---|---|
|
|
Number of rows in SWT cache groups inserted on the Oracle database. |
|
|
Number of rows in SWT cache groups updated on the Oracle database. |
|
|
Number of rows in SWT cache groups deleted on the Oracle database. |
|
|
Number of bytes sent to Oracle database during SWT cache group operations. |
Table 1-5 Local cache group statistics
| Name | Description |
|---|---|
|
|
Number of dynamic load queries that find the requested data within the TimesTen database. |
|
|
Number of dynamic load queries that do not find the requested data within the TimesTen database and need to load the data from the Oracle database. |
|
|
Number of data loads from the Oracle database when servicing dynamic load misses for dynamic local cache groups. |
|
|
Total number of bytes loaded from Oracle database for servicing dynamic load misses for dynamic local cache groups. |
Table 1-6 Grid operational statistics
| Name | Description |
|---|---|
|
|
Number of attach operations. |
|
|
Number of detach operations. |
Table 1-7 Dynamic global cache group statistics
| Name | Description |
|---|---|
|
|
Dynamic loads that find the data in the local grid member without requiring the data to be loaded from the Oracle database or another grid member. |
|
|
Dynamic loads that do not find data initially in the local grid member. The dynamic load must search the Oracle database or another grid member. |
|
|
Dynamic loads that do not find data in the local grid member and successfully load the data from a different grid member. |
|
|
Number of times a dynamic load miss had to load the requested data from the Oracle database. |
|
|
Total number of bytes loaded from the Oracle database for servicing dynamic load misses. |
|
|
Number of requests for data received by this grid member from another grid member as a result of a dynamic load on the remote grid member. |
|
|
Number of requests for data received by this grid member when the data requested was found not to be present on this grid member. |
|
|
Number of requests for data received by this grid member when the data requested was locked by a transaction on this grid member. |
|
|
Number of requests for data received by this grid member when the data requested is dirty and must first be propagated to the Oracle database. |
Table 1-8 Persistence statistics (logging and checkpointing)
| Name | Description |
|---|---|
|
|
Number of log records inserted into the log buffer. |
|
|
Number of bytes inserted into the log buffer. |
|
|
Total number of waits experienced by all insertion processes. |
|
|
Number of file system reads. |
|
|
Number of file system writes. |
|
|
Number of times the log has been synchronized to disk. |
|
|
Number of log files generated. |
|
|
Earliest log file that currently exists in the database. |
|
|
Most recent log file present. Same as |
|
|
Number of bytes read from the log for commit processing. |
|
|
Number of file system reads from the log for commit processing. |
|
|
Number of log bytes read during database recovery. |
|
|
Number of bytes written for checkpointing. |
|
|
Number of checkpoint writes. |
|
|
Number of checkpoints completed. |
|
|
Number of fuzzy checkpoints completed. |
|
|
Number of bytes written for checkpointing during database recovery. |
Table 1-9 User and system activity statistics
| Name | Description |
|---|---|
|
|
Number of statement prepares. |
|
|
Number of command cache misses during statement prepare. |
|
|
Number of statement reprepares, including forced and automatic. |
|
|
Number of automatic statement reprepares. |
|
|
Number of SQL statements executed. |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of transactions committed. |
|
|
Number of durable transaction commits. |
|
t |
Number of nondurable transaction commits. |
|
|
Number of durable replicated transaction commits. |
|
|
Number of nondurable replicated transaction commits. |
|
|
Number of replication-initiated transaction commits. |
|
|
Number of XLA-initiated transaction commits. |
|
|
Number of transaction rollbacks. |
|
|
Number of database connections established. |
|
|
Number of first database connections established. |
|
|
Number of direct-linked database connections established. |
|
|
Number of client/server connections established. |
|
|
Number of database connection threshold exceeded events. |
|
|
Number of database disconnects. |
Table 1-10 Database activity statistics
| Name | Description |
|---|---|
|
|
Number of table rows read. |
|
|
Number of table rows inserted. |
|
|
Number of table rows updated. |
|
|
Number of table rows deleted. |
|
|
Number of full table scans. |
|
|
Number of indexes rebuilt. |
|
|
Number of rows inserted into hash indexes. |
|
|
Number of rows inserted into hash indexes during index rebuild phase of database recovery. |
|
|
Number of rows deleted from hash indexes. |
|
|
Number of hash indexes scanned. |
|
|
Number of hash indexes scanned during replication operations (such as insert, update and delete operations on tables). |
|
|
Number of rows fetched from hash indexes. |
|
|
Number of rows fetched from hash indexes during replication operations. |
|
|
Number of rows inserted into range indexes. |
|
|
Number of rows inserted into range indexes during index rebuild phase of database recovery. |
|
|
Number of rows deleted from range indexes. |
|
|
Number of rows updated on range indexes. |
|
|
Number of range indexes scanned. |
|
|
Number of range indexes scanned during replication operations (such as insert, update and delete operations on tables). |
|
|
Number of rows fetched from range indexes. |
|
|
Number of rows fetched from range indexes during replication operations. |
|
|
Number of temporary indexes created. |
|
|
Number of temporary indexes scanned. |
|
|
Number of temporary indexes scanned during replication operations. |
|
|
Number of rows fetched from temporary indexes. |
|
|
Number of rows fetched from temporary indexes during replication operations. |
|
|
Number of sorts done. |
|
|
Number of nested loop joins done. |
|
|
Number of merge joins done. |
Table 1-11 Locking statistics
| Name | Description |
|---|---|
|
|
Number of locks granted immediately. |
|
|
Number of locks granted that required waiting. |
|
|
Number of lock timeouts. |
|
|
Number of deadlocks. |
|
|
Number of locks acquired for table scans. |
|
|
Number of locks acquired for DML activity. |
Table 1-12 Aging statistics
| Name | Description |
|---|---|
|
|
Number of time-based aging cycles completed since the data store was loaded into memory. |
|
|
Number of time-based aging commits since the data store was loaded into memory. |
|
|
Number of rows deleted during time-based aging since the data store was loaded into memory. |
|
|
Number of rows that were not deleted using time-based aging because of lock contention since the data store was loaded into memory. |
|
|
Number of LRU aging cycles completed since the data store was loaded into memory. |
|
|
Number of LRU aging commits since the data store was loaded into memory. |
|
|
Number of rows deleted during LRU aging since the data store was loaded into memory. |
|
|
Number of rows that were not deleted using LRU aging because of lock contention since the data store was loaded into memory. |
|
|
Number of times LRU aging high threshold has been reached since the data store was loaded into memory. |
|
|
Number of times LRU aging low threshold has been reached since the data store was loaded into memory. |
Table 1-13 Client/Server statistics
| Name | Description |
|---|---|
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of |
|
|
Number of transactions committed by server. |
|
|
Number of transaction rollbacks by server. |
|
|
Number of table rows inserted by server. |
|
|
Number of table rows updated by server. |
|
|
Number of table rows deleted by server. |
|
|
Number of client/server roundtrips. |
|
|
Number of client/server bytes transmitted by server. |
|
|
Number of client/server bytes received by server. |
|
|
Number of client/server disconnects. |
See also
The TABLE_PRIVILEGE_MAP system table describes privilege type codes. This table can be used to map privilege type numbers to type names.
Columns
| Column name | Type | Description |
|---|---|---|
PRIVILEGE | TT_INTEGER NOT NULL | Numeric privilege type code. |
NAME | VARCHAR2(40) INLINE NOT NULL | Name of the type of privilege. |
The TABLES table stores information about the tables in the database, including the name, the owner, the number of columns, the size of a row and the primary key (if any). The TABLES table also stores information on system tables.
Specific column information is stored in the COLUMNS table.
Columns
| Column name | Type | Description |
|---|---|---|
TBLNAME | TT_CHAR(31) NOT NULL | Table name. |
TBLOWNER | TT_CHAR(31) NOT NULL | Name of user who owns the table. |
OWNER | TT_INTEGER NOT NULL | Owner identification. |
NUMVARY | TT_SMALLINT NOT NULL | Number of varying-length columns in table. |
NUMNULL | TT_SMALLINT NOT NULL | Number of nullable columns in table. |
NUMCOLS | TT_SMALLINT NOT NULL | Number of columns in table. |
LENGTH | TT_INTEGER NOT NULL for 32-bit systems
| Length of inline portion of each row. |
NUMLOB | TT_SMALLINT NOT NULL | Number of LOB columns in the table. |
NUMCOMPRESS | TT_SMALLINT NOT NULL | Number of columns compressed in the table. |
TBLID | TT_INTEGER NOT NULL for 32-bit systems
| TimesTen identifier for table.
Matches |
NUMTUPS | TT_INTEGER NOT NULL for 32-bit systems
| Table cardinality. This value is precise only when no INSERT or DELETE transactions are active. The value includes uncommitted inserts, but not uncommitted deletes. Consequently, the value of this field may be larger than the actual table cardinality. |
MAXTUPS | TT_INTEGER NOT NULL for 32-bit systems
| Maximum table cardinality. |
PRIMCNT | TT_SMALLINT NOT NULL | Number of columns in primary key (0 if none). |
PRIMCOLS | BINARY(32) NOT NULL | Array of 2-byte integer column numbers of primary key, mapped to binary. |
CACHEFLAG | BINARY(1) NOT NULL | This column is for internal use. |
XLAFLAG | BINARY(1) NOT NULL | If set, updates to this table should be transmitted to the transaction log API. |
PXLAFLAG | BINARY(1) NOT NULL | If set, indicates that persistent XLA has been enabled for this particular user table. |
CACHEGROUP | TT_INTEGER NOT NULL for 32-bit systems
| ID of cache group that this table belongs to. This flag is non-zero if the table belongs to a cache group. |
OCACHEGROUP | TT_INTEGER NOT NULL for 32-bit systems
| Reserved for internal use. |
MVID | TT_INTEGER NOT NULL for 32-bit systems
| If TBLNAME is a view, indicates the ID of the associated row in the SYS.VIEWS system table. Otherwise, the value is 0. |
MVIDS | TT_VARCHAR(1024) NOT INLINE | If TBLNAME is a detail table, indicates the ID of an array that contains the rowids in SYS.VIEWS that correspond to a materialized view that references the detail table. |
CGFKIDS | TT_VARCHAR(8192) NOT INLINE | Reserved for future use. |
PERMLTBLID | TT_INTEGER NOT NULL for 32-bit systems
| The ID of the associated permanent table. |
CVVERSIONNUM | TT_INTEGER NOT NULL | Reserved for internal use. |
REPNUMKEYCOLS | TT_SMALLINT NOT NULL | Number of columns in the replication key described by REPKEYCOLS. |
REPTSCOLNUM | TT_SMALLINT NOT NULL | Column number of the column used for replication's timestamp-based conflict checking. |
REPRETURNSERVICE | TT_CHAR(1) NOT NULL | Return service for this subscriber with respect to this replication element:
' ' ' ' |
REPRETURNBYREQUEST | BINARY(1) NOT NULL | 0 - Return services are provided unconditionally
1 - Return services are provided only by request. This field is ignored if |
REPUSERID | TT_BIGINT NOT NULL | User-defined identifier for table (set with ttSetUserTableID built-in function). |
REPKEYCOLS | BINARY(32) NOT NULL | Column numbers used by replication for unique identification of a row.
(an array of 2-byte integers, mapped to binary) |
REPACCESS | TT_CHAR(1) NOT NULL | The access restrictions imposed by replication:
' ' ' '
|
REPTSUPDATERULE | TT_CHAR(1) NOT NULL | The rule for maintaining the TS_COLUMN for a timestamp-based conflict detector:
' ' ' |
CACHEDTBLPOS | TT_INTEGER NOT NULL | Reserved for future use. |
VALTBLIDS | VARBINARY(4000)NOT INLINE for 32-bit systems
| If the table contains compressed columns, indicates the ID of an array, containing the ID's of the corresponding dictionary tables. |
The TBL_STATS table stores the statistics for tables in the database, namely the number of rows in the table. No values are present if the statistics have not been computed.
Column-specific statistics are stored in the SYS.COL_STATS table.
Columns
| Column name | Type | Description |
|---|---|---|
TBLID | TT_INTEGER NOT NULL for 32-bit systems
| TimesTen identifier of table. |
NUMTUPS | TT_INTEGER NOT NULL for 32-bit systems
| Number of rows in the table. |
LASTSTATSUPDATE | TT_CHAR(25) | Time of most recent update of this table, in the following format:
Day Mon DD HH:MM:SS YYYY For example: Sun Jan 03 18:24:12 2010 The string is null-terminated. This column is |
The TCOL_STATS table stores the statistics for table columns in temporary table databases associated with active sessions. Statistics include the number of unique values, number of nulls, number of rows and other information regarding the distribution of column values. No values are present if statistics have not been computed.
Columns
| Column name | Type | Description |
|---|---|---|
TBLID | TT_INTEGER NOT NULL for 32-bit systems
| TimesTen table identifier. |
COLNUM | TT_SMALLINT NOT NULL | Ordinal number of column in table (starting at 1). |
INFO | VARBINARY(4194304) NOT NULL NOT INLINE | Contains a binary representative of the column value distribution information. See "ttOptUpdateStats" in Oracle TimesTen In-Memory Database Reference for an explanation of the distribution information stored in this column. A text representation of this information can be retrieved using the ttOptGetColStats built-in procedure. |
The TINDEXES table stores information about the indexes in the temporary table databases associated with active sessions, including the name, the type (range or hash), the index key and whether the index is unique.
Columns
| Column name | Type | Description |
|---|---|---|
IXNAME | TT_CHAR(31) NOT NULL | Index name. |
IXOWNER | TT_CHAR(31) NOT NULL | Name of index owner. |
IXID | TT_INTEGER NOT NULL for 32-bit systems
| TimesTen identifier of index. |
TBLID | TT_INTEGER NOT NULL for 32-bit systems
| TimesTen identifier of index's table. |
IXTYPE | TT_INTEGER NOT NULL | Index type:
0 - hash index. 1 - range index. |
ISUNIQUE | BINARY(1) NOT NULL | Uniqueness:
0 - nonunique index. 1 - unique index. |
ISPRIMARY | BINARY(1) NOT NULL | Primary key:
0 - not a primary key for table. 1 - primary key for table. |
USETMPHEAP | TT_SMALLINT NOT NULL | |
KEYCNT | TT_SMALLINT NOT NULL | Number of columns in the index key. |
KEYCOLS | BINARY(32) NOT NULL | Array of 2-byte integer column numbers of index key, mapped to binary. |
PAGESPARAM | TT_INTEGER NOT NULL for 32-bit systems
| Number of pages specified for hash index. |
NLSSORTID | TT_INTEGER NOT NULL | For internal use only. |
NLSSORTPARM | VARBINARY(1000) NOT INLINE | For internal use only. |
NLSSORTSTR | TT_VARCHAR(200) NOT INLINE | For internal use only. |
NLSSORTBUFSIZE | TT_SMALLINT | For internal use only. |
NLSSORTMAXSIZE | TT_SMALLINT | For internal use only. |
HAKANFACTOR | TT_INTEGER NOT NULL | For internal use only. |
The TRANSACTION_LOG_API table keeps track of the persistent Transaction Log API bookmarks. Each row in the system table corresponds to a persistent bookmark. Each persistent bookmark has a text identifier associated with it that is used to keep track of the bookmark.
Columns
| Column name | Type | Description |
|---|---|---|
ID | TT_CHAR(31) NOT NULL | A text tag identifier used to keep track of the bookmark. |
READLSNHIGH | TT_INTEGER NOT NULL for 32-bit systems
| The high value of the read log record to which this bookmark points. |
READLSNLOW | TT_INTEGER NOT NULL for 32-bit systems
| The low value of the read log record to which this bookmark points. |
PURGELSNHIGH | TT_INTEGER NOT NULL for 32-bit systems
| The high value of the lowest LSN required by this bookmark. |
PURGELSNLOW | TT_INTEGER NOT NULL for 32-bit systems
| The low value of the lowest LSN required by this bookmark. |
PID | TT_INTEGER NOT NULL for 32-bit systems
| The process ID of the process to last open the XLA bookmark. |
INUSE | BINARY(1) NOT NULL | Bookmark being used by any persistent Transaction Log API connection. |
REPLICATED | BINARY(1) | Used for a replicated bookmark. Internal use only. |
COUNTER | TT_BIGINT | Used for a replicated bookmark. Internal use only. |
COUNTER_A | TT_BIGINT | Used for a replicated bookmark. Internal use only. |
COUNTER_B | TT_BIGINT | Used for a replicated bookmark. Internal use only. |
CTN_HIGH_A | TT_INTEGER for 32-bit systems
| Used for a replicated bookmark. Internal use only. |
CTN_LOW_A | TT_INTEGER for 32-bit systems
| Used for a replicated bookmark. Internal use only. |
CTN_HIGH_B | TT_INTEGER for 32-bit systems
| Used for a replicated bookmark. Internal use only. |
CTN_LOW_B | TT_INTEGER for 32-bit systems
| Used for a replicated bookmark. Internal use only. |
The TTABLES table stores information about temporary table databases associated with active sessions, including the name, the owner, the number of columns, the size of a row and the primary key (if any).
Specific column information is stored in the COLUMNS table.
Columns
| Column name | Type | Descriptions |
|---|---|---|
TBLNAME | TT_CHAR(31) NOT NULL | Table name. |
TBLOWNER | TT_CHAR(31) NOT NULL | Name of user who owns the table. |
OWNER | TT_INTEGER NOT NULL | Owner of table:
0 - TimesTen system table. 1 - User table. |
NUMVARY | TT_SMALLINT NOT NULL | Number of varying-length columns in table. |
NUMNULL | TT_SMALLINT NOT NULL | Number of nullable columns in table. |
NUMCOLS | TT_SMALLINT NOT NULL | Number of columns in table. |
LENGTH | TT_INTEGER NOT NULL for 32-bit systems
| Length of inline portion of each row. |
NUMLOB | TT_SMALLINT NOT NULL | Number of LOB columns in table. |
NUMCOMPRESS | TT_SMALLINT NOT NULL | Number of columns compressed in table. |
TBLID | TT_INTEGER NOT NULL for 32-bit systems
| TimesTen identifier for table. |
NUMTUPS | TT_INTEGER NOT NULL for 32-bit systems
| Table cardinality. This value is precise only when no INSERT or DELETE transactions are active. The value includes uncommitted inserts, but not uncommitted deletes. Consequently, the value of this field may be larger than the actual table cardinality. |
MAXTUPS | TT_INTEGER NOT NULL for 32-bit systems
| Maximum table cardinality. |
PRIMCNT | TT_SMALLINT NOT NULL | Number of columns in primary key (0 if none). |
PRIMCOLS | BINARY (32) NOT NULL | Array of 2-byte integer column numbers of primary key, mapped to binary. |
CACHEFLAG | BINARY(1) NOT NULL | 1 - if the table is in a cache group
0 otherwise |
XLAFLAG | BINARY(1) NOT NULL | If set, updates to this table should be transmitted to the transaction log API. |
PXLAFLAG | BINARY(1) NOT NULL | If set, indicates that persistent XLA has been enabled for this particular user table. |
CACHEGROUP | TT_INTEGER NOT NULL for 32-bit systems
| ID of cache group that this table belongs to. |
OCACHEGROUP | TT_INTEGER NOT NULL for 32-bit systems
| Reserved for internal use. |
MVID | TT_INTEGER NOT NULL for 32-bit systems
| If the table is a view, indicates the ID of the associated row in the SYS.VIEWS system table. |
MVIDS | TT_VARCHAR(1024) NOT INLINE | If the table is a view detail table, indicates the ID of the array or the IDs of the rows in the SYS.VIEWS system table of the materialized views that reference this detail table. |
CGFKIDS | TT_VARCHAR (8192) NOT INLINE | Reserved for future use. |
PERMLTBLID | TT_INTEGER NOT NULL | The associated permanent table's ID. |
CVVERSIONNUM | TT_INTEGER NOT NULL | Reserved for internal use. |
REPNUMKEYCOLS | TT_SMALLINT NOT NULL | Number of columns in the replication key described by REPKEYCOLS. |
REPTSCOLNUM | TT_SMALLINT NOT NULL | Column number of the column used for replication's timestamp-based conflict checking. |
REPRETURNSERVICE | TT_CHAR(1) NOT NULL | Return service for this subscriber with respect to this replication element:
' ' ' ' |
REPRETURNBYREQUEST | BINARY(1) NOT NULL | 0 - Return services are provided unconditionally
1 - Return services are provided only by request. This field is ignored if |
REPUSERID | TT_BIGINT NOT NULL | User-defined identifier for table (set with the ttSetUserTableID built-in procedure). |
REPKEYCOLS | BINARY(32) NOT NULL | Column numbers used by replication for unique identification of a row (an array of 2-byte integers, mapped to binary). |
REPACCESS | TT_CHAR(1) NOT NULL | The access restrictions imposed by replication:
' ' ' '
|
REPTSUPDATERULE | TT_CHAR(1) NOT NULL | The rule for maintaining the TS_COLUMN for a timestamp-based conflict detector:
' ' ' |
CACHEDTBLPOS | TT_INTEGER NOT NULL | Reserved for future use. |
VALTBLIDS | VARBINARY(4000)NOT INLINE for 32-bit systems
| If the table contains compressed columns, indicates the ID of an array, containing the ID's of the corresponding dictionary tables. |
The TTBL_STATS table stores the statistics for temporary table databases associated with active sessions, namely the number of rows in the table. No values are present if the statistics have not been computed.
Column-specific statistics are stored in the SYS.COL_STATS table.
Columns
| Column name | Type | Description |
|---|---|---|
TBLID | TT_INTEGER NOT NULL for 32-bit systems
| TimesTen identifier of table. |
NUMTUPS | TT_INTEGER NOT NULL for 32-bit systems
| Number of rows in the table. |
LASTSTATSUPDATE | TT_CHAR(25) | Time of most recent update of this table, in the following format:
Day Mon DD HH:MM:SS YYYY For example: Sun Jan 03 18:24:12 2010 The string is null-terminated. This column is |
USER_ARGUMENTS describes the arguments of the procedures and functions that are owned by the current user. This view does not display the OWNER column. See "SYS.ALL_ARGUMENTS" for column descriptions.
Related views
This view returns no rows. The column definitions are the same as the column definitions for the SYS.USER_COL_PRIVS view in the Oracle Database. See Oracle Database Reference.
Related views
SYS.ALL_COL_PRIVS returns no rows.
SYS.DBA_COL_PRIVS returns no rows.
USER_DEPENDENCIES describes dependencies between objects that are owned by the current user.
Related views
Columns
| Column name | Type | Description |
|---|---|---|
NAME | VARCHAR2(30) INLINE | Object name. |
TYPE | VARCHAR2(17) INLINE NOT NULL | Object type. |
REFERENCED_OWNER | VARCHAR2(30) INLINE | Owner of the referenced object. |
REFERENCED_NAME | VARCHAR2(30) INLINE | Name of the referenced object. |
REFERENCED_TYPE | VARCHAR2(17) INLINE NOT NULL | Type of the referenced object. |
REFERENCED_LINK_NAME | VARCHAR2(128) INLINE | Ignored. |
SCHEMAID | NUMBER | ID of the current schema. |
DEPENDENCY_TYPE | VARCHAR2(4) INLINE NOT NULL | Indicates whether the dependency is a REF dependency (REF) or not (HARD). |
USER_ERRORS describes the current errors on the stored objects that are owned by the current user. This view does not display the OWNER column. See "SYS.ALL_ERRORS" for column descriptions.
Related views
USER_IDENTIFIERS describes the identifiers for all stored objects that are owned by the current user. This view does not display the OWNER column. See "SYS.ALL_IDENTIFIERS" for column descriptions.
Related views
USER_OBJECTS describes all objects owned by the current user. This view does not display the OWNER column. See "SYS.ALL_OBJECTS" for column descriptions.
Related views
USER_OBJECT_SIZE describes the size, in bytes, of PL/SQL objects owned by the current user. This view does not display the OWNER column. See "SYS.DBA_OBJECT_SIZE" for column descriptions.
Related views
USER_PLSQL_OBJECT_SETTINGS describes compiler settings for all stored objects that are owned by the current user. This view does not display the OWNER column. See "SYS.DBA_PLSQL_OBJECT_SETTINGS" for column descriptions.
Related views
USER_PROCEDURES describes all functions and procedures, along with associated properties that are owned by the current user. This view does not display the OWNER column. See "SYS.ALL_PROCEDURES" for column descriptions.
Related views
USER_SOURCE describes the text source of the stored objects that are owned by the current user. This view does not display the OWNER column. See "SYS.ALL_SOURCE" for column descriptions.
Related views
USER_STORED_SETTINGS describes the persistent parameter settings for stored PL/SQL units, but shows only information about PL/SQL units owned by the current user. See "SYS.ALL_STORED_SETTINGS" for column descriptions.
Related views
The USER_SYNONYMS view describes the synonyms owned by the current user. This view does not display the OWNER column. See "SYS.ALL_SYNONYMS" for column descriptions.
Related views
The USER_SYS_PRIVS view lists the system privileges of the current user.
Related views
SYS.DBA_SYS_PRIVS lists the system privileges granted to all users and to PUBLIC.
Columns
| Column name | Type | Description |
|---|---|---|
USERNAME | VARCHAR2(30) INLINE | User name. |
PRIVILEGE | VARCHAR2(40) INLINE NOT NULL | Privilege name. |
ADMIN_OPTION | VARCHAR2(3) INLINENOT NULL | Indicates whether the user can grant the privilege. Possible values are YES and NO.
The value is |
The SYS.USER_TABLES view describes all tables owned by the current user. This view does not display the OWNER column. See "SYS.ALL_TABLES" for column descriptions.
Related views
The USER_TAB_PRIVS view lists the object privileges granted to the current user, the object privileges granted by the current user, and the list of object privileges granted for objects owned by the current user.
Related views
Columns
| Column name | Type | Description |
|---|---|---|
GRANTEE | VARCHAR2(30) INLINE | Name of the user with the privilege. |
OWNER | VARCHAR2(30) INLINE | Object owner. |
TABLE_NAME | VARCHAR2(30) INLINE | Object name. |
GRANTOR | VARCHAR2(30) INLINE | Name of the user who granted the privilege. |
PRIVILEGE | VARCHAR2(40) INLINE NOT NULL | Privilege name. |
GRANTABLE | VARCHAR2(3) INLINE NOT NULL | Value is always NO. |
HIERARCHY | VARCHAR2(3) INLINE NOT NULL | Value is always NO. |
The USER_TAB_SIZES view contains the information about the size of tables that are owned by the current user. This view has the same columns as SYS.ALL_TAB_SIZES but does not include the OWNER column.
Related views
The USER_USERS view describes the current user.
Related views
Columns
| Column name | Type | Description |
|---|---|---|
USERNAME | VARCHAR2(30) INLINE | Name of the user. |
USER_ID | TT_INTEGER NOT NULL | ID number of the user. |
ACCOUNT_STATUS | VARCHAR2(32) INLINE NOT NULL | Value is OPEN. |
LOCK_DATE | TT_TIMESTAMP | Value is NULL. |
EXPIRY_DATE | TT_TIMESTAMP | Value is NULL. |
DEFAULT_TABLESPACE | VARCHAR2(30) INLINE NOT NULL | Value is USERS. |
TEMPORARY_TABLESPACE | VARCHAR2(30) INLINE NOT NULL | Value is TEMP. |
CREATED | TT_TIMESTAMP NOT NULL | Date when the user was created. |
INITIAL_RSRC_CONSUMER_GROUP | VARCHAR2(30) INLINE | Value is always NULL. |
EXTERNAL_NAME | VARCHAR2(4000) NOT INLINE | Value is always NULL. |
The SYS.USER_VIEWS view describes all tables owned by the current user. This view does not display the OWNER column. See "SYS.ALL_VIEWS" for column descriptions.
Related views
The VIEWS table stores the statistics for views in the database.
Columns
| Column name | Type | Description |
|---|---|---|
NAME | TT_CHAR(31) NOT NULL | View name. |
OWNER | TT_CHAR(31) NOT NULL | View owner. |
ID | TT_INTEGER NOT NULL for 32-bit systems
| ID of the view row. |
TBLID | TT_INTEGER NOT NULL for 32-bit systems
| ID of the view. |
SQL | TT_VARCHAR(409600) NOT INLINE NOT NULL | View SELECT statement. |
REFRESH_INTERVAL | TT_BIGINT | Refresh interval in seconds |
REFRESH_START | TT_TIMESTAMP | The start time of the most recent refresh |
REFRESH_END | TT_TIMESTAMP | The ending time of the most recent refresh |
REFRESH_ROWCNT | TT_INTEGER | Number of rows refreshed in the most recent refresh |
The XLASUBSCRIPTIONS table stores information needed for table subscriptions at the bookmark level.
Columns
| Column name | Type | Description | |
|---|---|---|---|
BOOKMARK | TT_CHAR(31) NOT NULL | Bookmark name. | |
TBLNAME | TT_CHAR(31) NOT NULL | The name of the subscribed table. | |
TBLOWNER | TT_CHAR(31) NOT NULL | Owner of the subscribed table. |
TimesTen stores metadata about replication in replication tables in your database.
Your applications can read the replication tables, but it cannot update them. If your application defines a table with the same name as a replication table, then your application can read a replication table by prefixing the replication table name with TTREP. For example, SELECT * FROM TTREP.REPTABLES selects rows from the REPTABLES replication table.
Information specific to replication tables:
Locks acquired by users on replication tables may prevent others from defining data or executing the SQLPrepare ODBC function or the Connection.prepareStatement JDBC method.
The last character in name columns is always a space. Therefore, while the column length for name columns is 31, the maximum object name length is 30.
On 64-bit systems, TimesTen replication tables declare certain fields as data type TT_BIGINT. When retrieving these columns with an ODBC program, the application must bind them using SQL_C_BINARY. For information about SQL_C_BINARY, see ODBC documentation.
|
Note: Some tables contain columns namedSYSnumber. Because these columns contain values used internally by TimesTen, they are not documented in this chapter. |
The TTREP.CLIENTFAILOVER table is reserved for internal or future use.
By default PUBLIC has SELECT privileges on various system and replication tables and EXECUTE privileges on various PL/SQL objects. You can see the list of objects by using this query:
SELECT * FROM sys.dba_tab_privs WHERE grantee='PUBLIC';
The ADMIN or SELECT ANY TABLE privilege is required to access other system and replication tables and views.
The REPELEMENTS table describes elements in a replication scheme.
Columns
| Column name | Type | Description |
|---|---|---|
REPLICATION_NAME | TT_CHAR(31) NOT NULL | Name for a replication scheme. |
REPLICATION_OWNER | TT_CHAR(31) NOT NULL | The replication scheme's owner. |
ELEMENT_NAME | TT_CHAR(31) NOT NULL | The replication name for this element, logically different from the DS_OBJ_NAME of the underlying data base object. For example, the ELEMENT_NAME for a replicated table may differ from the table name. This name must be unique in a replication scheme. |
ELEMENT_TYPE | TT_CHAR(1) NOT NULL | The type of this replication element:
' ' ' |
OWNED_BY_SYSTEM | BINARY(1) NOT NULL | 0x01 - Element is maintained by the system and cannot be directly referenced by SQL statements.
|
MASTER_ID | TT_BIGINT NOT NULL | The TT_STORE_ID for the master or propagator of this element. |
OLD_MASTER_ID | TT_BIGINT NOT NULL | The TT_STORE_ID for the immediately preceding MASTER for this element.
-1 if none. |
IS_PROPAGATOR | BINARY(1) NOT NULL | 0 if the MASTER_ID identifies a true MASTER database.
1 if |
DS_OBJ_NAME | TT_CHAR(31) NOT NULL | If this replication refers to a single, underlying data base object, then this is its name. Specifically, it is the name of the replicated table if ELEMENT_TYPE = 'T'.
It is
|
DS_OBJ_OWNER | TT_CHAR(31) NOT NULL | The owner of the replication element – if defined. NULL otherwise. This is always the owner of the table. DS_OBJ_OWNER.DS_OBJ_NAME need not be unique in a replication scheme, but each occurrence must be associated with a distinct ELEMENT_NAME. |
DS_OBJ_ID | TT_INTEGER for 32-bit systems
| If the ELEMENT_TYPE = 'T':
Table ID - Table is in the owning (master or propagator) database. 1- Table is in the subscriber database. If the 0 - Database is a master or propagator. 1- Database is a subscriber.
|
DURABLE_TRANSMIT | BINARY(1) NOT NULL | 0 - Transactions are not made durable before they are transmitted.
1 - Transactions are made durable before they are transmitted (default). |
CONFLICT_CHECKS | BINARY(8) NOT NULL | A bit map indicating which conflict detectors are enabled. This field is either: 0x0000000000000000 (no configured conflict detector, the default) or: 0x0000000000000001 (ROW TIMESTAMP conflict detector). |
TS_COLUMN_NAME | TT_CHAR(31) | The name of the timestamp column specified in the CHECK CONFLICTS clause of a CREATE REPLICATION statement. This column must be of type BINARY(8) and permit NULL values. |
TS_EXCEPTION_ACTION | TT_CHAR(1) NOT NULL | The action to take upon detecting a conflict by a timestamp-based detector. The action is specified by the ON EXCEPTION clause in the CHECK CONFLICTS clause of a CREATE REPLICATION statement. They appear in this column as:
' ' ' |
TS_UPDATE_RULE | TT_CHAR(1) NOT NULL | The rule for maintaining the timestamp for a timestamp-based conflict detector:
' ' ' |
TS_REPORT_FILE | TT_VARCHAR(1000) NOT INLINE | The name of the file to which the replication agent reports timestamp conflicts.
This file is specified by the |
IS_MASTER_PROPAGATOR | BINARY(1) | Indicates if the database is both a master and a propagator. |
EXTERNAL_DB | TT_CHAR(1) | Indicates replication to a database that is not TimesTen:
|
REPORT_FORMAT | TT_CHAR(1) | The report format for the replication conflict file:
' ' |
The REPLICATIONS table collects together general information about all replication schemes in which the local database participates. The table indicates whether a replication scheme was created by ttRepAdmin -upgrade or by a CREATE MATERIALIZED VIEW statement.
Columns
| Column name | Type | Description |
|---|---|---|
REPLICATION_NAME | TT_CHAR(31) NOT NULL | Name for a replication scheme. |
REPLICATION_OWNER | TT_CHAR(31) NOT NULL | The replication scheme's owner. |
REPLICATION_ORIGIN | TT_CHAR(1) NOT NULL | 'U' - created by ttRepAdmin -upgrade
' |
REPLICATION_VERSION | TT_INTEGER NOT NULL | The number of ALTER REPLICATION commands applied to this replication scheme after its initial creation. |
SOURCE_STORE_ID_ALIGN | TT_INTEGER NOT NULL | Used internally to properly align the SOURCE_STORE_ID column. |
SOURCE_STORE_ID | TT_BIGINT NOT NULL | If this replication scheme was created by restoring it from a backup, the database ID of the database from which this replication scheme was backed up and restored. otherwise -1 (the invalid database ID). |
CHECKSUM | TT_BIGINT | Indicates that the replication scheme has been updated. |
The REPNETWORK table stores information on interfaces used by the replication agent when two peers communicate. Each row represents a communication path between master and subscriber and describes either the sending or receiving interface used.
Columns
| Column name | Type | Description |
|---|---|---|
REPLICATION_NAME | TT_CHAR(31) NOT NULL | Name of the replication scheme. |
REPLICATION_OWNER | TT_CHAR(31) NOT NULL | The owner of the replication scheme. |
TT_STORE_ID | TT_BIGINT NOT NULL | Unique, system-generated identifier for a HOST_NAME/TT_STORE_NAME pair. |
SUBSCRIBER_ID | TT_BIGINT NOT NULL | The identifier for a database that subscribes to at least one replication element owned by TT_STORE_ID. |
HOST_NAME | TT_VARCHAR(200) NOT NULL NOT INLINE | Name associated with the network interface. |
PRIORITY | TT_INTEGER NOT NULL | Integer from 1-99 that denotes the priority of the IP address. |
INTERFACE | TT_CHAR(1) NOT NULL | Indicates whether the HOST_NAME refers to an interface on the sending side ('S') or on the receiving side ('R'). |
The REPPEERS table displays status information about the stores in a replication scheme. After the initial upgrade, the REPPEERS table contains peer information only about the local database and other databases that it transmits updates to.
Columns
| Column name | Type | Description |
|---|---|---|
REPLICATION_NAME | TT_CHAR(31) NOT NULL | Name for a replication scheme. |
REPLICATION_OWNER | TT_CHAR(31) NOT NULL | The replication scheme's owner |
TT_STORE_ID | TT_BIGINT NOT NULL | Unique, system-generated identifier for a HOST_NAME/TT_STORE_NAME pair. |
SUBSCRIBER_ID | TT_BIGINT NOT NULL | The identifier for a database that subscribes to at least one replication element owned by TT_STORE_ID. If a valid ID then this record describes the status of TT_STORE_ID/SUBSCRIBER_ID as a sender/subscriber pair. |
COMMIT_TIMESTAMP | TT_INTEGER for 32-bit systems
| This field and COMMIT_SEQNUM together store the value of the Commit Ticket Number of the refreshed transaction that the subscriber has just committed. |
COMMIT_SEQNUM | TT_INTEGER for 32-bit systems
| This field and COMMIT_TIMESTAMP together store the value of the Commit Ticket Number of the refreshed transaction that the subscriber has just committed. |
SENDLSNHIGH | TT_INTEGER for 32-bit systems
| The log file number of the highest TT_STORE_ID log sequence number sent to and acknowledged by SUBSCRIBER_ID. |
SENDLSNLOW | TT_INTEGER for 32-bit systems
| The log file offset of the highest TT_STORE_ID log sequence number sent to and acknowledged by SUBSCRIBER_ID. |
REPTABLESLSNHIGH | TT_INTEGER for 32-bit systems
| For TimesTen internal use. |
REPTABLESLSNLOW | TT_INTEGER for 32-bit systems
| For TimesTen internal use. |
STATE | TT_INTEGER | The state of replication kept by TT_STORE_ID with respect to this SUBSCRIBER_ID:
|
TIMESEND | TT_INTEGER | The timestamp (in seconds) for the time of the last known successful transmission from TT_STORE_ID to SUBSCRIBER_ID. |
TIMERECV | TT_INTEGER | The timestamp (in seconds) for the time TT_STORE_ID last received a transmission from SUBSCRIBER_ID. |
PROTOCOL | TT_INTEGER | A number in the range 0 to 5 indicating the protocol level that replication uses for communication between TT_STORE_ID and SUBSCRIBER_ID. A higher number indicates a newer protocol. |
LATENCY | BINARY_DOUBLE | An estimate of the time interval (in seconds) from the commit of a transaction on TT_STORE_ID to its receipt of acknowledgement that it has been applied at the subscriber identified by SUBSCRIBER_ID. |
TPS | TT_INTEGER | An estimate of the number of tra8}ǂnsactions per second that are committed on TT_STORE_ID and successfully received by the subscriber identified by SUBSCRIBER_ID. |
RECSPERSEC | TT_INTEGER | An estimate of the number of records per second retrieved by the subscriber identified by SUBSCRIBER_ID from the database TT_STORE_ID. |
TRACK_ID | TT_TINYINT | Identifies a replication track used in user-specified parallel replication. |
CTNLISTINDEX | TT_INTEGER | For internal use by the replication agent. |
The REPSTORES table lists the replication attributes of databases that participate in every TimesTen replication scheme in which the local database participates. Each database is identified by a unique TT_STORE_ID that TimesTen replication assigns to it. A TT_STORE_ID may appear at most once for a given replication scheme, but may appear multiple times in the REPSTORES table. Various replication schemes may define different replication attributes for the same database.
Columns
| Column name | Type | Description | |
|---|---|---|---|
REPLICATION_NAME | TT_CHAR(31) NOT NULL | Name for a replication scheme. | |
REPLICATION_OWNER | TT_CHAR(31) NOT NULL | The replication scheme's owner | |
TT_STORE_ID | TT_BIGINT NOT NULL | Unique, system-generated identifier for a HOST_NAME/TT_STORE_NAME pair. | |
PEER_TIMEOUT | TT_INTEGER NOT NULL | The number of seconds for this database to wait for a subscriber response before trying to reconnect. | |
FAIL_THRESHOLD | TT_INTEGER NOT NULL | The number of log files whose accumulation makes this database, in this replication scheme, mark subscribers "failed." (See the STATE field in TTREP.REPPEERS.) | |
HEARTBEAT_FACTOR | BINARY_DOUBLE | A multiplier of the current heartbeat frequency. |
The REPSBUBSCRIPTIONS table registers each subscribing database that maintains a secondary copy of a replication element.
Columns
| Column name | Type | Description |
|---|---|---|
REPLICATION_NAME | TT_CHAR(31) NOT NULL | Name for a replication scheme. |
REPLICATION_OWNER | TT_CHAR(31) NOT NULL | The replication scheme's owner. |
ELEMENT_NAME | TT_CHAR(31) NOT NULL | The replication name for this element, logically distinct from the name of an underlying database object. |
SUBSCRIBER_ID | TT_BIGINT NOT NULL | The TT_STORE_ID for a subscriber to this element. A subscriber may not subscribe more than once to a replication element in a replication scheme. |
RETURN_SERVICE | TT_CHAR(1) NOT NULL | Return service for this subscriber with respect to this replication element:
' ' ' ' |
RETURN_BY_REQUEST | BINARY(1) NOT NULL | The type of return services for this element.
0 - Return services are provided unconditionally 1 - Return services are provided only by request This field is ignored if |
PRIVILEGES | TT_CHAR(1) NOT NULL | Privileges for this subscriber with respect to this replication element:
' |
The REPTABLES table contains subscriber-relative information about each of the columns in each table transmitted to a subscriber. This information appears in REPTABLES in the owner (transmitter) database but not in REPTABLES in the subscriber database.
Columns
| Column name | Type | Description |
|---|---|---|
REPLICATION_NAME | TT_CHAR(31) NOT NULL | Name for a replication scheme. |
REPLICATION_OWNER | TT_CHAR(31) NOT NULL | The replication scheme's owner. |
ELEMENT_NAME | TT_CHAR(31) NOT NULL | The replication name for this element, logically different from the REF_NAME of the underlying data base object. For example, the ELEMENT_NAME for a replicated table may differ from the table name. This name must be unique in a replication scheme. |
SUBSCRIBER_ID | TT_BIGINT NOT NULL | The TT_STORE_ID for a subscriber to this element. A subscriber may not subscribe more than once to a replication element in a replication scheme. |
COLNUM | TT_SMALLINT NOT NULL | Ordinal number of column in table (starting at 1). |
COLOPTIONS | BINARY(1) NOT NULL | Column specification flags:
0x01 - column is in a primary key 0x02 - column value is varying length data type ( 0x04 - column value can be 0x08 - column values are unique |
COLTYPE | TT_INTEGER NOT NULL | Data type of column 1 TT_CHAR2 TT_DECIMAL3 TT_DECIMAL4 TT_INTEGER5 TT_SMALLINT6 BINARY_FLOAT7 BINARY_FLOAT8 BINARY_DOUBLE9 TT_DATE10 TIME11 TT_TIMESTAMP12 TT_VARCHAR13 DATE14 TIMESTAMP15 NUMBER16 CHAR17 VARCHAR218 NCHAR19 NVARCHAR2- 1 LONGVARCHAR- 2 BINARY- 3 VARBINARY- 4 LONGVARBINARY- 5 TT_BIGINT- 6 TT_TINYINT- 7 BIT- 8 WCHAR- 9 WVARCHAR- 10 WLONGVARCHAR |
COLLEN | TT_INTEGER NOT NULL for 32-bit systems
| Length of the column (maximum length for varying-length columns). |
COLPRECISION | TT_INTEGER NOT NULL | The number of digits in a fixed-point number, or the number of digits in the mantissa of a floating point number. |
COLSCALE | TT_INTEGER NOT NULL | A non-negative number. A scale of 0 indicates an integer with no digits to the right of a decimal point. For a scale of S, the exact numeric value is the integer value of the significant digits multiplied by:
|
PTNNUM | TT_SMALLINT NOT NULL | The table partition that contains the column. |
PTNCOLOFF | TT_INTEGER NOT NULL for 32-bit systems
| The offset of the column within the partition. |
PTNNULLOFF | TT_INTEGER NOT NULL for 32-bit systems
| The offset to the null byte within the partition. |
REPKEYPOSITION | TT_SMALLINT NOT NULL | The ordinal position of this column in the replication key described by the REPKEYCOLS. |
TS_EXCEPTION_ACTION | TT_CHAR(1) NOT NULL | The action to take upon detecting a conflict by a timestamp-based detector. The action is specified by the ON EXCEPTION clause in the CHECK CONFLICTS of a CREATE REPLICATION statement. They appear in this column as:
' ' |
PNBOFF | TT_INTEGER | For internal use only. |
NULLMASK | TT_TINYINT | For internal use only. |
COLNAME | TT_CHAR(31) | Column name. |
The TTSTORES table maps the host name and database name to a unique TT_STORE_ID. The TT_STORE_ID is a foreign key for all other replication schema tables that refer to a database in a replication scheme.
Columns
| Column name | Type | Description |
|---|---|---|
TT_STORE_ID | TT_BIGINT NOT NULL | Unique, system-generated identifier for a HOST_NAME/TT_STORE_NAME pair. |
HOST_NAME | TT_VARCHAR(200) NOT NULL NOT INLINE | Name of the participating host node. |
TT_STORE_NAME | TT_VARCHAR(200) NOT NULL NOT INLINE | The name for this database. |
IS_LOCAL_STORE | BINARY(1) NOT NULL | 1 if this TT_STORE_ID represents the local database.
0 otherwise. |
MAJOR_RELEASE | TT_INTEGER NOT NULL | The major release part of this database's TimesTen release number. 0 indicates the current release. |
MINOR_RELEASE | TT_INTEGER NOT NULL | The minor release part of this store's TimesTen release number. |
REP_SCHEMA_VERSION | TT_INTEGER NOT NULL | The version of the replication schema in this database. |
REP_PORT_NUMBER | TT_INTEGER NOT NULL | The port number that replication uses to communicate with this database. 0 if automatically assigned. |
RRPOLICY | TT_CHAR(1) | Subscribers affected by return service failure policy. Legal values are:
' ' ' |
RRTRIGGER | TT_INTEGER | Number of timeouts before the return service failure policy is triggered. |
RRRESUME_LATENCY | TT_INTEGER | Resume latency in milliseconds. |
RRDURABLE | BINARY(1) | Durable commits on RETURN RECEIPT failure. Legal values are:
1 - True 0 - False |
RET_LOCAL_ACTION | TT_CHAR(1) | Default commit behavior for RETURN TWOSAFE transactions:
' ' |
RET_WAIT_TIME | TT_INTEGER | The defaulted timeout value for RETURN TWOSAFE transactions. |
RET_WHEN_STOPPED | BINARY(1) | If either the replication agent for the database is stopped or if the database is used as master and the replication agent for the database is set to STOP, then if the value of the column is a non-zero value, return services for the database are suspended. |
COMPRESSION | TT_CHAR(1) | If Y, indicates compression of all data from the database. |
MASTER | TT_CHAR(1) | Active or standby database or subscriber database. Values are:
' '
|
ROLE | TT_CHAR(1) | Role is one of:
' '
|
TS | TT_BIGINT | The timestamp at which the specified role change was made. |
CONFLICT_REPORT_STOP | TT_INTEGER | The threshold at which conflict reporting is stopped. |
CONFLICT_REPORT_RESTART | TT_INTEGER | The rate at which conflict reporting is resumed. |
CONFLICT_REPORT_FLUSH_METHOD | TT_INTEGER | Reserved for future use. |
TABLECHECK | TT_CHAR(1) | One of the following values:
|
