Skip Headers
Oracle® TimesTen In-Memory Database System Tables and Limits Reference
Release 11.2.1

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

Go to previous page
Previous
Go to next page
Next
View PDF

1 System Tables 

TimesTen stores metadata (information about the contents of your data store) in system tables in your data store.

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:

Tables and views reserved for internal or future use

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:

Required privileges to access system tables and views

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 unless otherwise noted in the description of the table or view.


SYS.ALL_ARGUMENTS

The ALL_ARGUMENTS view lists the arguments of the procedures and functions that are accessible to the current user.

Related views

Columns

Column name Type Description
OWNER VARCHAR2 (30) NOT NULL Object owner.
OBJECT_NAME VARCHAR2 (30) NOT NULL Object name.
PACKAGE_NAME VARCHAR2 (30) 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) 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 ARGUMENT_NAME, POSITION, SEQUENCE, and DATA_LEVEL are interdependent. Together, as a tuple, they represent a node of a flattened tree.

ARGUMENT_NAME can refer to:

  • Return type, if ARGUMENT_NAME is NULL and DATA_LEVEL = 0

  • The argument that appears in the argument list if ARGUMENT_NAME is NOT NULL and DATA_LEVEL = 0

  • Attribute name of the composite type if ARGUMENT_NAME is NOT NULL and DATA_LEVEL > 0

  • A collection element type if ARGUMENT_NAME is NULL and DATA_LEVEL > 0

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 DATA_LEVEL is greater than 0, then this column contains the position of this item with respect to its siblings at the same DATA_LEVEL. For a referenced record field, this is the index of the field within the record. For a referenced collection element, this is 1 because collection elements do not have siblings.

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) Data type of the argument.
DEFAULTED VARCHAR2 (1) 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) 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) Character set name for the argument.
TYPE_OWNER VARCHAR2 (30) Owner of the type of the argument.
TYPE_NAME VARCHAR2 (30) 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) 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) 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) 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) NOT NULL Indicates whether the byte limit (B) or char limit (C) is official for the string.


SYS.ALL_COL_PRIVS

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.ALL_DEPENDENCIES

The ALL_DEPENDENCIES describes dependencies between procedures, packages, functions, package bodies, and triggers accessible to the current user. This view does not display the SCHEMAID column.

Related views

Columns

Column name Type Description
OWNER VARCHAR2 (30) NOT NULL Object owner.
NAME VARCHAR2 (30) NOT NULL Object name.
TYPE VARCHAR2 (12) NOT NULL Object type.
REFERENCED_OWNER VARCHAR2 (30) NOT NULL Owner of the referenced object.
REFERENCED_NAME VARCHAR2 (30) NOT NULL Name of the referenced object.
REFERENCED_TYPE VARCHAR2 (12) NOT NULL Type of the referenced object.
REFERENCED_LINK_NAME VARCHAR2 (128) Ignored.
SCHEMAID TT_INTEGER NOT NULL ID of the current database.
DEPENDENCY_TYPE VARCHAR2 (4) NOT NULL Indicates whether the dependency is a REF dependency (REF) or not (HARD).


SYS.ALL_DIRECTORIES

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) NOT NULL Directory owner
DIRECTORY_NAME VARCHAR2 (30) NOT NULL Directory name
DIRECTORY_PATH VARCHAR2 (4000) Directory path


SYS.ALL_ERRORS

The ALL_ERRORS describes the current errors on the stored objects accessible to the current user.

Related views

Columns

Column name Type Description
OWNER VARCHAR2 (30) NOT NULL Object owner.
NAME VARCHAR2 (30) NOT NULL Object name.
TYPE VARCHAR2 (12) 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) NOT NULL Indicates whether the error is an error (ERROR) or a warning (WARNING).
MESSAGE_NUMBER TT_INTEGER Numeric error number (without any prefix).


SYS.ALL_IDENTIFIERS

The ALL_IDENTIFIERS view displays information about the identifiers in the stored objects accessible to the current user.

Related views

Columns

Column name Type Description
OWNER VARCHAR2 (30) NOT NULL Identifier owner.
NAME VARCHAR2 (30) Identifier name.
SIGNATURE CHAR (32) Signature of the identifier.
TYPE VARCHAR2 (18) NOT NULL Identifier type.
OBJECT_NAME VARCHAR2 (30) NOT NULL Name of the object where the identifier action occurred.
OBJECT_TYPE VARCHAR2 (13) NOT NULL Type of the object where the identifier action occurred.
USAGE VARCHAR2 (11) 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.


SYS.ALL_OBJECTS

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 data stores created with a release version earlier than 11.2.1.4.0.

Related views

Columns

Column name Type Description
OWNER VARCHAR2 (30) NOT NULL Object owner.
OBJECT_NAME VARCHAR2 (30) NOT NULL Object name.
SUBOBJECT_NAME VARCHAR2 (30) 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 (12) 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) NOT NULL Timestamp for the specification of the object (character data).
STATUS VARCHAR2 (7) NOT NULL Status of the object (VALID, INVALID, or N/A).
TEMPORARY VARCHAR2 (1) 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 'Y'.

GENERATED VARCHAR2 (1) NOT NULL Indicates whether the name of this object was system generated (Y or N).

Will always be 'N'.

SECONDARY VARCHAR2 (1) NOT NULL Whether there is a secondary object created by the ODCIIndexCreate method of the Oracle Data Cartridge (Y or N).

Will always be 'N'.

NAMESPACE TT_INTEGER NOT NULL Namespace for the object.
EDITION_NAME VARCHAR2 (30) Is ignored.


SYS.ALL_PLSQL_OBJECT_SETTINGS

The ALL_PLSQL_OBJECT_SETTINGS view displays information about the compiler settings for the stored objects accessible to the current user.

Related views

Columns

Column name Type Description
OWNER VARCHAR2 (30) NOT NULL Object owner.
NAME VARCHAR2 (30) NOT NULL Object name.
TYPE VARCHAR2 (12) 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 Settings for using PL/Scope.


SYS.ALL_PROCEDURES

The ALL_PROCEDURES view describes all PL/SQL functions and procedures, along with associated properties, that are accessible to the current user.

Related views

Columns

Column name Type Description
OWNER VARCHAR2 (30) NOT NULL Owner of the procedure or function.
OBJECT_NAME VARCHAR2 (30) NOT NULL Name of the object: top-level function, procedure or package name.
PROCEDURE_NAME VARCHAR2 (30) 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 (12) NOT NULL Object type.
AGGREGATE VARCHAR2 (3) Indicates if object is an aggregate function (YES or NO).

TimesTen does not support aggregate functions so value is 'N'.

PIPELINED VARCHAR2 (3) Indicates if object is a pipelined table function (YES or NO).

TimesTen does not support PIPELINED so value is 'N'.

IMPLTYPEOWNER VARCHAR2 (30) Name of owner of the implementation type, if any.
IMPLTYPENAME VARCHAR2 (30) Name of the implementation type, if any.
PARALLEL VARCHAR2 (3) Indicates whether the procedure or function is parallel-enabled (YES or NO).

TimesTen does not support PARALLEL, so value is 'N'.

You can specify the parallel_enable_clause, but it has no effect.

INTERFACE VARCHAR2 (3) YES, if the procedure or function is a table function implemented using the ODCI interface; otherwise NO.

TimesTen does not support INTERFACE so value is 'N'.

DETERMINISTIC VARCHAR2 (3) YES, if the procedure or function is declared to be deterministic; otherwise NO.
AUTHID VARCHAR2 (12) NOT NULL Indicates whether the procedure or function is declared to execute as DEFINER or CURRENT_USER (invoker).


SYS.ALL_SOURCE

The ALL_SOURCE view describes the text source of the stored objects accessible to the current user.

Related views

Columns

Column name Type Description
OWNER VARCHAR2 (30) NOT NULL Object owner.
NAME VARCHAR2 (30) NOT NULL Object name.
TYPE VARCHAR2 (12) 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.


SYS.ALL_STORED_SETTINGS

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

Columns

Column name Type Description
OWNER VARCHAR2 (30) NOT NULL Name of the database user owning the stored PL/SQL unit.
OBJECT_NAME VARCHAR2 (30) NOT NULL Name of the PL/SQL unit.
OBJECT_ID TT_BIGINT NOT NULL Object number of the PL/SQL unit.
OBJECT_TYPE VARCHAR2 (12) NOT NULL The type of the PL/SQL unit: PROCEDURE,FUNCTION, PACKAGE or PACKAGE BODY.
PARAM_NAME VARCHAR2 (30) 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; however, it is not less than 255.


SYS.ALL_SYNONYMS

The ALL_SYNONYMS view describes the synonyms accessible to the current user. These criteria determine the list of synonyms that ALL_SYNONYMS shows:

The base object can be a table, view, synonym, sequence, PL/SQL stored procedure, PL/SQL function, PL/SQL package, materialized view or cache group.

Related views

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) Reserved for future use. The value is always NULL.


SYS.ALL_TAB_PRIVS

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

Columns

Column Type Description
GRANTOR VARCHAR2(30) NOT NULL Name of the user who granted the privilege
GRANTEE VARCHAR2(30) NOT NULL Name of the user who has the privilege
TABLE_SCHEMA VARCHAR2(30) NOT NULL Object owner
TABLE_NAME VARCHAR2(31) NOT NULL Object name
PRIVILEGE VARCHAR2(40) NOT NULL Privilege name
GRANTABLE VARCHAR2(3) NOT NULL Value is always NO.
HIERARCHY VARCHAR2(3) NOT NULL Value is always NO.


SYS.ALL_USERS

The ALL_USERS view lists all users of the database that are visible to the current user.

Related views

Columns

Column Type Description
USERNAME VARCHAR2(30) NOT NULL 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


SYS.CACHE_GROUP

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;

TT_BIGINT NOT NULL for 64-bit systems

Id of this cache group.
ROOT TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

Unique identifier for cache group's root table
SOURCE TT_CHAR (8) NOT NULL Data source for caching. In this release the only legal value is 'ORACLE'.
CGDURATION TT_INTEGER NOT NULL Duration
TBLCNT TT_SMALLINT NOT NULL Number of tables in cache group.
REFRESH_MODE TT_CHAR (1) NOT NULL The current auto refresh mode.

'N': No auto refresh.

'I': Incremental auto refresh.

'F': Full auto refresh.

REFRESH_STATE TT_CHAR (1) NOT NULL The current auto refresh mode.

'N': Off.

'Y': On.

'P': Paused.

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 - READONLY

Bit 1: 1 - SYNCHRONOUS WRITETHROUGH

Bit 2: 1 - AUTOREFRESH

Bit 3: 1 - PROPAGATE

Bit 8: 1 - Autoload on create (Always 1 for AUTOREFRESH)

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 at Oracle, 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

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


SYS.COLUMNS

The COLUMNS table describes every column in every table in the data store, 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;

TT_BIGINT NOT NULL for 64-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 (VARCHAR[2], NVARCHAR[2],VARBINARY).

0x04 - column value can be NULL.

0x08 - column values are unique.

COLTYPE TT_INTEGER NOT NULL Data type of column
 1     TT_SMALLINT
 2     TT_INTEGER
 3     BINARY_FLOAT
 4     BINARY_DOUBLE
 5     TT_CHAR
 6     TT_VARCHAR
 7     BINARY
 8     VARBINARY
11     TT_DECIMAL
12     TT_NCHAR
13     TT_NVARCHAR
14     TT_DATE
15     TIME
16     TT_TIMESTAMP
20     TT_TINYINT
21     TT_BIGINT
22     TT_VARCHAR (inline)
23     VARBINARY (inline)
24     TT_NVARCHAR (inline)
25     NUMBER
26     CHAR
27     VARCHAR2
28     NCHAR
29     NVARCHAR2
30     DATE
31     TIMESTAMP
32     VARCHAR2 (inline)
33     NVARCHAR2 (inline)
34     ROWID

Note: If you are using TimesTen type mode, for information on COLTYPE, refer to documentation from previous releases of TimesTen. For information on TimesTen type mode, see "TimesTen type mode (backward compatibility)" in Oracle TimesTen In-Memory Database SQL Reference.

TYPE_ATTR TT_INTEGER NOT NULL Reserved for internal use.
COLLEN TT_INTEGER NOT NULL for 32-bit systems;

BIGINT NOT NULL for 64-bit systems

Length of the column (maximum length for varying-length columns).
INLINELEN TT_INTEGER NOT NULL 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 function).
DEFAULTVALSTR TT_VARCHAR (409600) NOT INLINE The default column value.
CHAR_USED TT_CHAR (1) Indicates the semantics for the column:

'B' for BYYE

'C' for CHAR

NULL for non-character columns



SYS.COL_STATS

The COL_STATS table stores the statistics for table columns in the data store. 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;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen table identifier.
COLNUM TT_SMALLINT NOT NULL Ordinal number of column in table (starting at 1).
INFO VARBINARY (4000000) NOT INLINE NOT NULL Contains a binary representative of the column value distribution information. See ttOptUpdateStats for an explanation of the distribution information stored in this column. A text representation of this information can be retrieved using ttOptGetColStats.


SYS.DBA_ARGUMENTS

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.


SYS.DBA_COL_PRIVS

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.DBA_DEPENDENCIES

DBA_DEPENDENCIES describes all dependencies between objects in the database. This view does not display the SCHEMAID column. See "SYS.ALL_DEPENDENCIES" for column descriptions.


SYS.DBA_DIRECTORIES

DBA_DIRECTORIES describes all directories in the database. It has the same columns as SYS.ALL_DIRECTORIES.


SYS.DBA_ERRORS

DBA_ERRORS describes the current errors on all stored objects in the database. It has the same columns as SYS.ALL_ERRORS.


SYS.DBA_IDENTIFIERS

DBA_IDENTIFIERS displays information about the identifiers in all stored objects in the database. It has the same columns as SYS.ALL_IDENTIFIERS.


SYS.DBA_OBJECTS

DBA_OBJECTS describes all objects in the database. It has the same columns as SYS.ALL_OBJECTS.


SYS.DBA_OBJECT_SIZE

The DBA_OBJECT_SIZE view describes the size, in bytes, of PL/SQL objects.

Related views

Columns

Column name Type Description
OWNER VARCHAR2 (30) NOT NULL Object owner.
NAME VARCHAR2 (30) NOT NULL Object name.
TYPE VARCHAR2 (12) 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.


SYS.DBA_PLSQL_OBJECT_SETTINGS

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.


SYS.DBA_PROCEDURES

DBA_PROCEDURES all PL/SQL functions and procedures, along with associated properties. It has the same columns as SYS.ALL_PROCEDURES.


SYS.DBA_SOURCE

DBA_SOURCE describes the text source of all stored objects. It has the same columns as SYS.ALL_SOURCE.


SYS.DBA_STORED_SETTINGS

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.


SYS.DBA_SYNONYMS

The DBA_SYNONYMS view describes all synonyms in the database. It has the same columns as SYS.ALL_SYNONYMS.


SYS.DBA_SYS_PRIVS

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 Type Description.
GRANTEE VARCHAR2(30) NOT NULL Name of the user with the privilege
PRIVILEGE VARCHAR2(40) NOT NULL Privilege name
ADMIN OPTION VARCHAR2(3) NOT NULL Indicates whether the user can grant the privilege. Possible values are YES and NO.

The value is YES only for the ADMIN privilege.



SYS.DBA_TAB_PRIVS

The DBA_TB_PRIVS view lists the object privileges granted to all users and to PUBLIC.

Related views

Required privileges

ADMIN

Columns

Column Type Description
GRANTEE VARCHAR2(30) NOT NULL Name of the user with the privilege
OWNER VARCHAR2(31) NOT NULL Object owner
TABLE_NAME VARCHAR2(31) NOT NULL Object name
GRANTOR VARCHAR2(30) NOT NULL Name of the user who granted the privilege
PRIVILEGE VARCHAR2(40) NOT NULL Privilege name
GRANTABLE VARCHAR2(3) NOT NULL Value is always NO.
HIERARCHY VARCHAR2(3) NOT NULL Value is always NO.


SYS.DBA_USERS

The DBA_USERS view describes all users of the database.

Related views

Columns

Column Type Description.
USER_NAME VARCHAR2(30) NOT NULL Name of the user
USER_ID TT_INTEGER NOT NULL ID number of the user
ACCOUNT_STATUS TT_VARCHAR2(32) NOT NULL Value is OPEN.
LOCK_DATE TT_TIMESTAMP Value is NULL.
EXPIRY_DATE TT_TIMESTAMP Value is NULL.
DEFAULT_TABLESPACE VARCHAR2(30) NOT NULL Value is USERS.
TEMPORARY_TABLESPACE VARCHAR2(30) NOT NULL Value is TEMP.
CREATED TT_TIMESTAMP NOT NULL Date when the user was created
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) Value is NULL.
EXTERNAL_NAME VARCHAR2(4000) Value is NULL.


SYS.DUAL

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'


SYS.INDEXES

The INDEXES table stores information about the indexes in the data store, 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;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen identifier of index.
TBLID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen identifier of indexed table.
IXTYPE TT_INTEGER NOT NULL Index type:

0 - hash index

1 - range index

2 - bitmap 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 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;

TT_BIGINT NOT NULL for 64-bit systems

Number of pages specified for hash index.
NLSSORTID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

For internal use only.
NLSSORTPARM VARBINARY (1000) NOT INLINE For internal use only.
NLSSORTSTR TT_VARCHAR(200) NOT INLINE For internal use only.
NLSSORTBUF

SIZE

TT_SMALLINT For internal use only.
NLSSORTMAX

SIZE

TT_SMALLINT NOT NULL For internal use only.
HAKANFACTOR TT_INTEGER NOT NULL For internal use only.


SYS.MONITOR

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 data store is loaded into memory and statistics are cleared when the data store is unloaded from memory. With a ramPolicy of manual or always, the data store 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:

For most columns, the MONITOR table is reset whenever there are no connections to the data store. TimesTen does not reset the values of the following columns, even when there are no connections to the data store:

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 the SYS.SYSTEMSTATS table if the desired statistic is not in the SYS.MONITOR table.

Columns

Column name Type Description
TIME_OF_1ST_CONNECT TT_CHAR (32) NOT NULL Time at which the first connection was made.
DS_CONNECTS TT_INTEGER NOT NULL Number of connects to the data store.
DS_DISCONNECTS TT_INTEGER NOT NULL Number of disconnects from the data store.
DS_CHECKPOINTS TT_INTEGER NOT NULL Number of checkpoints taken.
DS_CHECKPOINTS_FUZZY TT_INTEGER NOT NULL Number of fuzzy checkpoints taken.
DS_COMPACTS TT_INTEGER NOT NULL Number of data store compactions.
PERM_ALLOCATED_SIZE TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

Allocated size in kilobytes of the permanent data partition
PERM_IN_USE_SIZE TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

Size in kilobytes of the portion of the permanent data partition that is currently in use.
PERM_IN_USE_HIGH_WATER TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

The highest amount (in kilobytes) of permanent data partition memory in use since the first connection to the data store. The value of this field can be reset to the current value of the PERM_IN_USE_SIZE attribute by using the ttMonitorHighWaterReset procedure.
TEMP_ALLOCATED_SIZE TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

Allocated size in kilobytes of the temporary data partition
TEMP_IN_USE_SIZE TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

Size in kilobytes of the portion of the temporary data partition that is currently in use.
TEMP_IN_USE_HIGH_

WATER

TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

The highest amount (in kilobytes) of temporary data partition memory in use since the first connection to the data store. The value of this field can be reset to the current value of the TEMP_IN_USE_SIZE attribute by using the ttMonitorHighWaterReset procedure.
TPL_FETCHES TT_BIGINT NOT NULL Number of times TimesTen fetches data from Oracle into TimesTen using transparent load.
TPL_EXECS TT_BIGINT NOT NULL Number of times TimesTen communicates with Oracle to transparently load data into TimesTen. This count also includes attempts to perform a transparent load when there is no data to fetch from Oracle.
CACHE_HITS TT_BIGINT NOT NULL Number of times TimesTen successfully finds the required data in TimesTen.
PASSTHROUGH_COUNT TT_BIGINT NOT NULL Number of successful passthrough executions.
XACT_BEGINS TT_BIGINT NOT NULL Number of -transactions started.
XACT_COMMITS TT_BIGINT NOT NULL Number of durable and nondurable transactions -committed.
XACT_D_COMMITS TT_BIGINT NOT NULL Number of transactions committed durably.
XACT_ROLLBACKS TT_BIGINT NOT NULL Number of transactions rolled back.
LOG_FORCES TT_BIGINT NOT NULL Number of times log files were synchronized to disk.
DEADLOCKS TT_BIGINT NOT NULL Number of deadlocks.
LOCK_TIMEOUTS TT_BIGINT NOT NULL Number of lock requests denied due to timeouts.
LOCK_GRANTS_IMMED TT_BIGINT NOT NULL Number of lock requests granted without a wait.
LOCK_GRANTS_WAIT TT_BIGINT NOT NULL Number of lock requests granted after a wait.
CMD_PREPARES TT_BIGINT NOT NULL Number of commands prepared (compiled).
CMD_REPREPARES TT_BIGINT NOT NULL Number of commands re-prepared.
CMD_TEMP_INDEXES TT_BIGINT NOT NULL Number of temporary indexes created during query -execution.
LAST_LOG_FILE TT_INTEGER NOT NULL Number of last log file.
REPHOLD_LOG_FILE TT_INTEGER NOT NULL Number of last log file held by replication.
REPHOLD_LOG_OFF TT_INTEGER NOT NULL Offset in last log file held by replication.
REP_XACT_COUNT TT_INTEGER NOT NULL The number of replicated transactions generated on the local store that are being replicated to at least one peer data store.
REP_CONFLICT_COUNT TT_INTEGER NOT NULL The number of replicated transactions that ran into a conflict when being applied on the local store.
REP_PEER_CONNECTIONS TT_INTEGER NOT NULL The sum of all peer connections initiated by the local replication agent. There is one connection for every peer relationship where the local store is the master. If a transport level failure results in the establishment of a new connection, this count is incremented.
REP_PEER_RETRIES TT_INTEGER NOT NULL The number of retry attempts while trying to establish a new peer connection.
FIRST_LOG_FILE TT_INTEGER NOT NULL The number of the oldest existing (not yet purged) log file.
LOGBYTES_TO_LOG_BUFFER TT_BIGINT NOT NULL The number of bytes written to the log since first connect. This value includes the sizes of actual log records plus any log overhead.
LOG_FS_READS TT_BIGINT NOT NULL The number of times that a log read could not be satisfied from the in-memory log buffer.
LOG_FS_WRITES TT_BIGINT NOT NULL The number of times TimesTen has written the contents of the in-memory log buffer to the operating system. This column does not count the number of times data was flushed to disk. It counts writes to the operating system's file buffers.
LOG_BUFFER_WAITS TT_BIGINT NOT NULL The number of times a thread was delayed while trying to insert a log record into the log buffer because the log buffer was full. Generally speaking, if this value is increasing, it indicates that the log buffer is too small.
CHECKPOINT_BYTES_WRITTEN TT_INTEGER NOT NULL for 32-bit systems

TT_BIGINT NOT NULL for 64-bit systems

The number of bytes written to disk by the most recent checkpoint operation.
CURSOR_OPENS TT_INTEGER NOT NULL for 32-bit systems

TT_BIGINT NOT NULL for 64-bit systems

Number of SELECT statements issued.
CURSOR_CLOSES TT_INTEGER NOT NULL for 32-bit systems

TT_BIGINT NOT NULL for 64-bit systems

Number of SELECT statements completed.
CHECKPOINT_BLOCKS_WRITTEN TT_INTEGER NOT NULL for 32-bit systems

TT_BIGINT NOT NULL for 64-bit systems

Total number of blocks written for all completed checkpoints. To improve I/O efficiency, multiple blocks may be coalesced into a single write or a single block may be split across multiple writes.
CHECKPOINT_WRITES TT_INTEGER NOT NULL for 32-bit systems

TT_BIGINT NOT NULL for 64-bit systems

Total number of write operations issued by all completed and in-progress checkpoints.
REQUIRED_RECOVERY TT_INTEGER NOT NULL 1: When the data store was initially loaded into RAM at TIME_OF_1ST_CONNECT, recovery ran. This means that the previous time the data store was in memory, the data store did not shut down cleanly. When it was loaded into memory this time, the log was replayed and other operations were performed in an attempt to recover data.

If DurableCommit had been set to 0, transactions could have been lost.

0: The data store was previously shut down cleanly. Thus the data store was restarted cleanly.

TYPE_MODE TT_INTEGER NOT NULL 0: Oracle mode.

1: TimesTen mode.


See also

SYS.SYSTEMSTATS


SYS.PLAN

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:

TblLkSerialScan -- full table scan

RowLkSerialScan -- full table scan

TblLkTtreeScan -- ttree scan

RowLkTtreeScan -- ttree scan

TblLkHashScan -- hash lookup

RowLkHashScan -- hash lookup

TblLkRowidScan -- rowid lookup

RowLkRowidScan -- rowid lookup

TblLkUpdate -- updates one or more rows

RowLkUpdate -- updates one or more rows

TblLkDelete -- deletes one or more rows

RowLkDelete -- deletes one or more rows

TblLkInsert -- inserts one or more rows

RowLkInsert -- inserts one or more rows

TmpTtreeScanTmpHashScan -- create a temporary index

NestedLoop [OuterJoin | SemiJoin] -- nested loop join (with optional outer join or semi-join)

MergeJoin -- merge join

OrderBy -- sorts rows (requires extra temp space)

SortedDistinct -- identifies distinct rows from a sorted list (requires minimal extra space)

Distinct -- identifies distinct rows from an

unsorted list (requires extra temporary space)

SortedGroupBy -- identifies distinct groups from a sorted list (requires minimal extra space)

GroupBy -- identifies distinct groups from an unsorted list (requires extra temp space)

TmpTable -- materializes intermediate results (requires extra temporary space)

TblLkUpdView -- updates a view based on changes to detail table(s)

RowLkUpdView -- updates a view based on changes to detail table(s)

OracleInsert -- flushes changes to Oracle

ZeroTblScan -- evaluates a predicate on a single set of values (no scan required)

ViewUniqueMatchScan -- uniquely identifies those view rows that need to be updated (requires extra temp space

TBLNAME TT_CHAR (31) Name of table scanned at this step.

Column is NULL if no table is scanned.

IXNAME TT_CHAR (31) Name of index used at this step.

T-tree index names may have a "(D)" after the name, which indicates a descending scan.

Column is NULL if no index is scanned.

PRED TT_VARCHAR (1024) Predicate applied during table or index scan or join. Column is NULL if no predicate applies.
OTHERPRED TT_VARCHAR (1024) Predicate applied after table or index scan or join. Column is NULL if no predicate applies.


SYS.PUBLIC_DEPENDENCY

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).


SYS.SEQUENCES

The SEQUENCES table contains all the information about sequences. Data from the system table is restored to the new data store 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;

TT_BIGINT NOT NULL on 64-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 data stores.


SYS.SESSION_ROLES

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.


SYS.SYSTEM_PRIVILEGE_MAP

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


SYS.SYSTEMSTATS

The SYSTEMSTATS table stores system-wide 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.

Table 1-1 Asynchronous writethrough (AWT) cache group statistics

Name Description

cg.awt.tt_txns

Number of TimesTen transactions propagated to the Oracle database

cg.awt.sql_mode.inserts.rows

Number of rows inserted into the Oracle database in SQL mode (CacheAWTMethod=0)

cg.awt.sql_mode.updates.rows

Number of rows updated in the Oracle database in SQL mode

cg.awt.sql_mode.deletes.rows

Number of rows deleted from Oracle database in SQL mode (CacheAWTMethod=0)

cg.awt.sql_mode.inserts.batches

Number of insert batches sent to the Oracle database in SQL mode (CacheAWTMethod=0)

cg.awt.sql_mode.updates.batches

Number of update batches sent to the Oracle database in SQL mode (CacheAWTMethod=0)

cg.awt.sql_mode.deletes.batches

Number of delete batches sent to the Oracle database in SQL mode (CacheAWTMethod=0)

cg.awt.sql_mode.bytes

Number of bytes sent to the Oracle database in SQL mode (CacheAWTMethod=0)

cg.awt.sql_mode.batches

Number of batches sent to the Oracle database in SQL mode (CacheAWTMethod=0)

cg.awt.plsql_mode.inserts.rows

Number of rows inserted into the Oracle database in PL/SQL mode (CacheAWTMethod=1)

cg.awt.plsql_mode.updates.rows

Number of rows updated in the Oracle database in PL/SQL mode (CacheAWTMethod=1)

cg.awt.plsql_mode.deletes.rows

Number of rows deleted from the Oracle database in PL/SQL mode (CacheAWTMethod=1)

cg.awt.plsql_mode.bytes

Number of bytes sent to the Oracle database in PL/SQL mode (CacheAWTMethod=1)

cg.awt.plsql_mode.batches

Number of PL/SQL block batches sent to the Oracle database (CacheAWTMethod=1)

cg.awt.calls_to_oracle

Number of calls made to the Oracle database for AWT writes

cg.awt.commits_on_oracle

Number of AWT transactions committed on the Oracle database

cg.awt.rollbacks_on_oracle

Number of rollbacks on the Oracle database because of errors

cg.awt.retries

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

cg.autorefresh.inserts.rows

Number of rows inserted in TimesTen during autorefresh from the Oracle database

cg.autorefresh.updates.rows

Number of rows updated in TimesTen during autorefresh from the Oracle database

cg.autorefresh.deletes.rows

Number of rows deleted in TimesTen during autorefresh from the Oracle database

cg.autorefresh.cycles.completed

Number of autorefresh cycles completed successfully on TimesTen

cg.autorefresh.cycles.failed

Number of autorefresh cycles that failed because of errors

cg.autorefresh.full_refreshes

Number of full refreshes triggered during autorefresh operations


Table 1-3 Cache group flush statistics

Name Description

cg.flush.execs

Number of flush cache group executions

cg.flush.rows

Number of rows flushed to the Oracle database

cg.flush.bytes

Number of bytes flushed to the Oracle database


Table 1-4 Synchronous writethrough (SWT) cache group statistics

Name Description

cg.swt.inserts.rows

Number of rows in SWT cache groups inserted into the Oracle database

cg.swt.updates.rows

Number of rows in SWT cache groups updated in the Oracle database

cg.swt.deletes.rows

Number of rows in SWT cache groups deleted from the Oracle database

cg.swt.bytes

Number of bytes sent to Oracle database during SWT cache group operations


Table 1-5 Local cache group statistics

Name Description

cg.dynamic.local.hits.count

Number of dynamic loads that find the requested data within the TimesTen database

cg.dynamic.local.misses.count

Number of dynamic loads that do not find the requested data within the TimesTen database and need to load the data from the Oracle database

cg.dynamic.local.misses.oracle.loads

Number of data loads from the Oracle database when servicing dynamic load misses for dynamic local cache groups

cg.dynamic.local.misses.oracle.bytes_loaded

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

grid.member.attaches

Number of attach operations

grid.member.detaches

Number of detach operations


Table 1-7 Dynamic global cache group statistics

Name Description

cg.dynamic.global.hits.count

Dynamic loads that find the data in the local grid member without requiring data to be loaded from the Oracle database or another grid member

cg.dynamic.global.misses.count

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.

cg.dynamic.global.misses.remote.loads.successes

Dynamic loads that do not find data in the local grid member and successfully load the data from a different grid member

cg.dynamic.global.misses.oracle

Number of times a dynamic load had to load the requested data from the Oracle database

cg.dynamic.global.misses.oracle.bytes_loaded

Total number of bytes loaded from the Oracle database for servicing dynamic load misses

cg.dynamic.global.requests.received

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

cg.dynamic.global.requests.received.data_not_present

Number of requests for data received by this grid member when the data requested was found not to be present on this grid member

cg.dynamic.global.requests.received.data_locked

Number of requests for data received by this grid member when the data requested was locked by a transaction on this grid member

cg.dynamic.global.requests.received.data_dirty

Number of requests for data received by this grid member when the data requested must first be propagated to the Oracle database


Table 1-8 Persistence statistics (logging and checkpointing)

Name Description

log.buffer.insertions

Number of log records inserted into the log buffer

log.buffer.bytes_inserted

Number of bytes inserted into the log buffer

log.buffer.waits

Total number of waits experienced by all insertion processes

log.file.reads

Number of file system reads

log.file.writes

Number of file system writes

log.forces

Number of times the log has been synchronized to disk

log.files.generated

Number of log files generated

log.file.earliest

Earliest log file that currently exists in the database

log.file.latest

Most recent log file present

log.commit.bytes.read

Number of bytes read from the log for commit processing

log.commit.file.reads

Number of file system reads from the log for commit processing

log.recovery.bytes.read

Number of log bytes read during database recovery

ckpt.bytes_written

Number of bytes written for checkpointing

ckpt.writes

Number of checkpoint writes

ckpt.completed

Number of checkpoints completed

ckpt.completed.fuzzy

Number of fuzzy checkpoints completed

ckpt.bytes_written.during_recovery

Number of bytes written for checkpointing during database recovery


Table 1-9 User and system activity statistics

Name Description

stmt.prepares.count

Number of statement prepares

stmt.prepares.command_cache_miss

Number of command cache misses during statement prepare

stmt.reprepares.count

Number of statement reprepares, including forced and automatic

stmt.reprepares.automatic

Number of automatic statement reprepares

stmt.executes.count

Number of SQL statements executed

stmt.executes.updates

Number of UPDATE statements executed

stmt.executes.deletes

Number of DELETE statements executed

stmt.executes.merges

Number of MERGE statements executed

stmt.executes.inserts

Number of INSERT statements executed

stmt.executes.selects

Number of SELECT statements executed

stmt.executes.alters

Number of ALTER statements executed

stmt.executes.creates

Number of CREATE statements executed

stmt.executes.drops

Number of DROP statements executed

txn.commits.count

Number of transactions committed

txn.commits.durable

Number of durable transaction commits

txn.commits.nondurable

Number of nondurable transaction commits

txn.commits.replicated.durable

Number of durable replicated transaction commits

txn.commits.replicated.nondurable

Number of nondurable replicated transaction commits

txn.commits.internal.replication

Number of replication-initiated transaction commits

txn.commits.internal.xla

Number of XLA-initiated transaction commits

txn.rollbacks

Number of transaction rollbacks

connections.established.count

Number of database connections established

connections.established.direct

Number of direct-linked database connections established

connections.established.client_server

Number of client/server connections established

connections.established.threshold_exceeded

Number of database connection threshold exceeded events

connections.disconnected

Number of database disconnects


Table 1-10 Database activity statistics

Name Description

db.table.rows_read

Number of table rows read

db.table.rows_inserted

Number of table rows inserted

db.table.rows_updated

Number of table rows updated

db.table.rows_deleted

Number of table rows deleted

db.table.full_scans

Number of full table scans

db.index.rebuilds

Number of indexes rebuilt

db.index.hash.inserts

Number of rows inserted into hash indexes

db.index.hash.inserts.recovery_rebuild

Number of rows inserted into hash indexes during index rebuild phase of database recovery

db.index.hash.deletes

Number of rows deleted from hash indexes

db.index.hash.scans.count

Number of hash indexes scanned

db.index.hash.scans.repl

Number of hash indexes scanned during replication operations (such as insert, update and delete operations on tables)

db.index.hash.rows_fetched.count

Number of rows fetched from hash indexes

db.index.hash.rows_fetched.repl

Number of rows fetched from hash indexes during replication operations

db.index.range.inserts.count

Number of rows inserted into range indexes

db.index.range.inserts.recovery_rebuild

Number of rows inserted into range indexes during index rebuild phase of database recovery

db.index.range.deletes

Number of rows deleted from range indexes

db.index.range.updates

Number of rows updated on range indexes

db.index.range.scans.count

Number of range indexes scanned

db.index.range.scans.repl

Number of range indexes scanned during replication operations (such as insert, update and delete operations on tables)

db.index.range.rows_fetched.count

Number of rows fetched from range indexes

db.index.range.rows_fetched.repl

Number of rows fetched from range indexes during replication operations

db.index.temporary.created

Number of temporary indexes created

db.index.temporary.scans.count

Number of temporary indexes scanned

db.index.temporary.scans.repl

Number of temporary indexes scanned during replication operations

db.index.temporary.rows_fetched.count

Number of rows fetched from temporary indexes

db.index.temporary.rows_fetched.repl

Number of rows fetched from temporary indexes during replication operations

db.sorts

Number of sorts done

db.joins.nested_loop

Number of nested loop joins done

db.joins.merge

Number of merge joins done


Table 1-11 Locking statistics

Name Description

lock.locks_granted.immediate

Number of locks granted immediately

lock.locks_granted.wait

Number of locks granted that required waiting

lock.timeouts

Number of lock timeouts

lock.deadlocks

Number of deadlocks

lock.locks_acquired.table_scans

Number of locks acquired for table scans

lock.locks_acquired.dml

Number of locks acquired for DML activity


See also

SYS.MONITOR


SYS.TABLE_PRIVILEGE_MAP

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


SYS.TABLES

The TABLES table stores information about the tables in the data store, 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 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;

TT_BIGINT NOT NULL for 64-bit systems

Length of in-line portion of each row.
TBLID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen identifier for table.
NUMTUPS TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-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;

TT_BIGINT NOT NULL for 64-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;

TT_BIGINT NOT NULL for 64-bit systems

ID of cache group that this table belongs to.
MVID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

If the table is a VIEW, indicates the ID of the associated row in the VIEWS system table
MVIDS TT_VARCHAR(1024) NOT INLINE If the table is a VIEW detail table, indicates the ID of the array of the Ids of the rows in the VIEWS system table of the materialized views that reference this detail table.
PERMLTBLID TT_INTEGER NOT NULL The associated permanent table's ID.
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:

'C' - RETURN COMMIT

'R' - RETURN RECEIPT

'2' - RETURN TWOSAFE

'\0' - NO RETURN services

REPRETURNBYREQUEST BINARY (1) NOT NULL 0 - RETURN services are provided unconditionally

1 - RETURN services are provided only BY REQUEST. This field is ignored if REPRETURNSERVICE = '\0'

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:

'-' - no access permitted

's'- may be read by read-only (SELECT) transactions

'r' -  may be read by updating transactions

'w' - may be updated

w => r and r => s.

REPTSUPDATERULE TT_CHAR (1) NOT NULL The rule for maintaining the TS_COLUMN for a timestamp-based conflict detector:

'\0' - rule not defined

'U' - BY USER

'S' - BY SYSTEM (default)

CACHETBLPOS TT_INTEGER NOT NULL Reserved for future use


SYS.TBL_STATS

The TBL_STATS table stores the statistics for tables in the data store, 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 COL_STATS table.

See "SYS.COL_STATS".

Columns

Column name Type Description
TBLID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen identifier of table.
NUMTUPS TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-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

(e.g., Sun Jan 01 18:24:12 1995).

The string is NULL-terminated.

This column is NULL if no statistics update has been performed on the table.



SYS.TCOL_STATS

The TCOL_STATS table stores the statistics for table columns in temporary table instances 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;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen table identifier.
COLNUM TT_SMALLINT NOT NULL Ordinal number of column in table (starting at 1).
INFO VARBINARY (4000000) NOT NULL NOT INLINE Contains a binary representative of the column value distribution information. See ttOptUpdateStats for an explanation of the distribution information stored in this column. A text representation of this information can be retrieved using ttOptGetColStats.


SYS.TINDEXES

The TINDEXES table stores information about the indexes in the temporary table instances 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's owner.
IXID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen identifier of index.
TBLID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-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;

TT_BIGINT NOT NULL for 64-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.
NLSSORTBUF

SIZE

TT_SMALLINT For internal use only.
NLSSORTMAXSIZE TT_SMALLINT For internal use only.


SYS.TRANSACTION_LOG_API

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, which is used to keep track of the bookmark.

These columns are for internal use: REPLICATED, ID_A, ID_B, CTN_HIGH_A, CTN_HIGH_B, CTN_LOW_A, CTN_LOW_B.

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 The high value of the read log record to which this bookmark points.
READLSNLOW TT_INTEGER NOT NULL The low value of the read log record to which this bookmark points.
PURGELSNHIGH TT_INTEGER NOT NULL The high value of the lowest LSN required by this bookmark.
PURGELSNLOW TT_INTEGER NOT NULL The low value of the lowest LSN required by this bookmark.
PID TT_INTEGER NOT NULL 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
COUNTER TT_BIGINT Used for a replicated bookmark
COUNTER_A TT_BIGINT Used for a replicated bookmark
COUNTER_B TT_BIGINT Used for a replicated bookmark
CTN_HIGH_A TT_INTEGER Used for a replicated bookmark
CTN_LOW_A TT_INTEGER Used for a replicated bookmark
CTN_HIGH_B TT_INTEGER Used for a replicated bookmark
CTN_LOW_B TT_INTEGER Used for a replicated bookmark


SYS.TTABLES

The TTABLES table stores information about temporary table instances 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;

TT_BIGINT NOT NULL for 64-bit systems

Length of in-line portion of each row.
TBLID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen identifier for table.
NUMTUPS TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-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;

TT_BIGINT NOT NULL for 64-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;

TT_BIGINT NOT NULL for 64-bit systems

Id of cache group that this table belongs to.
MVID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

If the table is a VIEW, indicates the ID of the associated row in the VIEWS system table
MVIDS TT_VARCHAR(1024) NOT INLINE If the table is a VIEW detail table, indicates the ID of the array of the Ids of the rows in the VIEWS system table of the materialized views that reference this detail table.
PERMLTBLID TT_INTEGER NOT NULL The associated permanent table's ID.
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:

'C' - RETURN COMMIT

'R' - RETURN RECEIPT

'2' - RETURN TWOSAFE

'\0' - NO RETURN services

REPRETURNBY

REQUEST

BINARY (1) NOT NULL 0 - RETURN services are provided unconditionally

1 - RETURN services are provided only BY REQUEST. This field is ignored if REPRETURNSERVICE = '\0'

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:

'-' - no access permitted

's'- may be read by read-only (SELECT) transactions

'r' -  may be read by updating transactions

'w' - may be updated

w => r and r => s.

REPTSUPDATERULE TT_CHAR (1) NOT NULL The rule for maintaining the TS_COLUMN for a timestamp-based conflict detector:

'\0' - rule not defined

'U' - BY USER

'S' - BY SYSTEM (default)



SYS.TTBL_STATS

The TTBL_STATS table stores the statistics for temporary table instances 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 COL_STATS table.

See "SYS.COL_STATS".

Columns

Column name Type Description
TBLID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

TimesTen identifier of table.
NUMTUPS TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-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

(e.g., Sun Jan 01 18:24:12 1995).

The string is NULL-terminated.

This column is NULL if no statistics update has been performed on the table.



SYS.USER_ARGUMENTS

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.


SYS.USER_COL_PRIVS

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.USER_DEPENDENCIES

USER_DEPENDENCIES describes dependencies between objects that are owned by the current user. This view does not display the OWNER column. See "SYS.ALL_DEPENDENCIES" for column descriptions.


SYS.USER_ERRORS

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.


SYS.USER_IDENTIFIERS

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.


SYS.USER_OBJECTS

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.


SYS.USER_OBJECT_SIZE

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.


SYS.USER_PLSQL_OBJECT_SETTINGS

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.


SYS.USER_PROCEDURES

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.


SYS.USER_SOURCE

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.


SYS.USER_STORED_SETTINGS

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.


SYS.USER_SYNONYMS

The USER_SYNONYMS view describes the synonyms owned by the current user. This view has the same columns as SYS.ALL_SYNONYMS except that it does not display the OWNER column.


SYS.USER_SYS_PRIVS

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 Type Description
USERNAME VARCHAR2(30) NOT NULL User name
PRIVILEGE VARCHAR2(40) NOT NULL Privilege name
ADMIN_OPTION VARCHAR2(3) NOT NULL Indicates whether the user can grant the privilege. Possible values are YES and NO.

The value is YES only for the ADMIN privilege.



SYS.USER_TAB_PRIVS

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 Type Description
GRANTEE VARCHAR2(30) NOT NULL Name of the user with the privilege
OWNER VARCHAR2(31) NOT NULL Object owner
TABLE_NAME VARCHAR2(31) NOT NULL Object name
GRANTOR VARCHAR2(30) NOT NULL Name of the user who granted the privilege
PRIVILEGE VARCHAR2(40) NOT NULL Privilege name
GRANTABLE VARCHAR2(3) NOT NULL Value is always NO.
HIERARCHY VARCHAR2(3) NOT NULL Value is always NO.


SYS.USER_USERS

The USER_USERS view describes the current user.

Related views

Columns

Column Type Description
USERNAME VARCHAR2(30) NOT NULL Name of the user
USER_ID TT_INTEGER NOT NULL ID number of the user
ACCOUNT_STATUS VARCHAR2(32) NOT NULL Value is OPEN.
LOCK_DATE TT_TIMESTAMP Value is NULL.
EXPIRY_DATE TT_TIMESTAMP Value is NULL.
DEFAULT_TABLESPACE VARCHAR2(30) NOT NULL Value is USERS.
TEMPORARY_TABLESPACE VARCHAR2(30) NOT NULL Value is TEMP.
CREATED TT_TIMESTAMP NOT NULL Date when the user was created.
INITIAL_RSRC_CONSUMER_GROUP VARCHAR2(30) Value is always NULL.
EXTERNAL_NAME VARCHAR2(4000) Value is always NULL.


SYS.VIEWS

The VIEWS table stores the statistics for views in the data store.

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;

TT_BIGINT NOT NULL for 64-bit systems

ID of the view row.
TBLID TT_INTEGER NOT NULL for 32-bit systems;

TT_BIGINT NOT NULL for 64-bit systems

ID of the view.
SQL TT_VARCHAR (409600) NOT NULL NOT INLINE 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


SYS.XLASUBSCRIPTIONS

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.