The database system contains a series of system tables. You will find a definition of some system tables here, which contain information about database objects and their connection to each other, statistics system tables, monitor system tables and loader system tables.
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.
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.
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 schema. You do not need to specify the schema to access these 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 system administrator schema. You do not need to specify the schema to access these tables.
The monitor system tables return results for the database system administrator 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.
The database system contains a range of Loader 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.
These upgrade system tables are available in the database system administrator schema and are only visible for the database system administrator.