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