Skip Headers
Oracle® TimesTen In-Memory Database SQL Reference
Release 11.2.1

Part Number E13070-04
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

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