Definitions of the System Tables 

System Tables with Information About Database Objects

The database system contains a series of system tables with information about the database objects and their relationships to each other. These system tables are available in the DOMAIN schema in every SQL mode. You have to specify the schema to access these tables in every SQL mode other than INTERNAL.

Definitions of the Most Important DOMAIN System Tables:

COLUMNS	CONNECTEDUSERS	CONNECTPARAMETERS
CONSTRAINTCOLUMNS	CONSTRAINTS	DBPROCEDURES
DBPROCPARAMS	DOMAINCONSTRAINTS	DOMAINS
FOREIGNKEYCOLUMNS	FOREIGNKEYS	FUNCTIONS
INDEXCOLUMNS	INDEXES	LOCKS
LOCK_WAITS	MAPCHARSETS	PACKAGES
ROLEPRIVILEGES	ROLES	SCHEMAPRIVILEGES
SCHEMAS	SEQUENCEPRIVILEGES	SEQUENCES
SESSION_ROLES	SYNONYMS	SYSTEMTRIGGERS
TABLEPRIVILEGES	TABLES	TRIGGERS
USERS	VERSIONS	VIEWCOLUMNS
VIEWDEFS	VIEWS	VIEWTABLES

System Tables with Information About Database States

The database system contains a series of system tables with information about the system configuration and system load. These system tables are available in the SYSINFO schema in every SQL mode. You do not need to specify the schema to access these tables.

Definitions of the Most Important SYSINFO System Tables:

ACTIVECONFIGURATION	BACKUPTHREADS	CACHESTATISTICS
CATALOGCACHESTATISTICS	COMMANDCACHESTATISTICS	COMMANDCACHESTATISTICSRESET
COMMANDSTATISTICS	COMMANDSTATISTICSRESET	CONSISTENTVIEWS
DATACACHE	DATASTATISTICS	DATASTATISTICSRESET
DATAVOLUMES	DATASTATISTICSRESET	FILEDIRECTORIES
FILES	HOTSTANDBYCOMPONENT	HOTSTANDBYGROUP
INSTANCE	IOBUFFERCACHES	IOTHREADSTATISTICS
IOTHREADSTATISTICSRESET	INDEXSIZE	INDEXSTORAGEDETAILS
LOGINFORMATION	LOGQUEUESTATISTICS	LOGQUEUESTATISTICSRESET
LOGSTATISTICS	LOGSTATISTICSRESET	LOGVOLUMES
MACHINECONFIGURATION	MACHINEUTILIZATION	MEMORYALLOCATORSTATISTICS
OPTIMIZERINFORMATION	READERWRITERLOCKINFORMATION	READERWRITERLOCKSTATISTICS
READERWRITERLOCKSTATISTICSRESET	READERWRITERLOCKWAITINGTASKS	REGIONINFORMATION
REGIONSTATISTICS	REGIONSTATISTICSRESET	RESTARTINFORMATION
SCHEMASIZE	SERVERTASKS	SESSIONS
SNAPSHOTS	SPINLOCKPOOLSTATISTICS	SPINLOCKPOOLSTATISTICSRESET
SPINLOCKSTATISTICS	SPINLOCKSTATISTICSRESET	TABLESIZE
TABLESTORAGEDETAILS	TASKGROUPSTATISTICS	TASKGROUPSTATISTICSRESET
TASKLOADBALANCINGINFORMATION	TASKLOADBALANCINGTASKGROUPSTATES	TASKLOADBALANCINGTASKMOVES
TRANSACTIONHISTORY	TRANSACTIONS	UNLOADEDSTATEMENTS
VERSION

Statistics System Tables

The database system contains a number of system tables that you can use to select information about the configuration, structures, and sizes of database objects. These statistics system tables are available in the database system administrator (SYSDBA user) schema. You do not need to specify the schema to access these tables.

Statistics System Tables

DBPARAMETERS	INDEXSTATISTICS	LOCKLISTSTATISTICS
OPTIMIZERSTATISTICS	SERVERDBSTATISTICS	SYSUPDATECOUNTERWANTED
SYSUPDSTATWANTED	TABLESTATISTICS	TRANSACTIONS
USERSTATISTICS

Monitor System Tables

The database system contains a number of system tables that you can use to access monitor information. These monitor system tables are available in the database systems administrator (SYSDBA user) schema. You do not need to specify the schema to access these tables.

The monitor system tables return results for the database system administrator (SYSDBA user) and for all users of the database user class database administrator (DBA user). Unauthorized users receive error message 100 – row not found.

The monitor system tables are structured as follows:

DESCRIPTION	CHAR(40)
VALUE	FIXED(20)

Each row contains a counter value that is described by the value contained in the DESCRIPTION column.

Monitor System Tables

MONITOR	MONITOR_CACHES	MONITOR_LOAD
MONITOR_LOCK	MONITOR_LOG	MONITOR_LONG
MONITOR_PAGES	MONITOR_REWRITE	MONITOR_ROW
MONITOR_TRANS

Loader System Tables

The database system contains a range of system tables that are used by the Loader. These Loader system tables are available in the SYSLOADER schema. You need to specify the schema SYSLOADER to access these tables.

Loader System Tables

CODEPAGE	MAPSCHEMANAMES	TRANSFORMATIONMODEL
TRANSFORMATIONMONITOR	TRANSFORMATIONPACKAGES	TRANSFORMATIONRESOURCES
TRANSFORMATIONSTATISTICS	TRANSFORMATIONSTEPS

Upgrade System Tables

These upgrade system tables are available in the database system administrator (SYSDBA user) schema.

The upgrade system tables are only visible for the database system administrator (SYSDBA user).

Upgrade System Tables

POSTUPGRADECHECKLIST	POSTUPGRADECHECKLIST<version>	POSTUPGRADECHECKLISTUNICODE
SYSUPGRADEHISTORY