Definitions of the System Tables 
System Tables with Information on Database Objects
The SAP DB database
system contains a series of system tables that
contain information about the database objects and their connection to each
other. These system tables are available in every 
SQL mode. Their owner is the
DOMAIN
user. The owner has to be specified when accessing these tables in every SQL
mode other than INTERNAL.
Definitions of the most important system tables:
|
|
|
Statistics System Tables
The SAP DB database
system contains a number of system tables that you can use to select
information about the configuration, structures, and sizes of database
objects. The owner of these statistics system tables is the SYSDBA user. You
do not need to specify the owner when accessing these tables.
Statistics System Tables
|
|
Monitor System Tables
The SAP DB database
system contains a number of system tables that you can use to access monitor
information. The owner of these monitor system tables is the SYSDBA user. You
do not need to specify the owner when accessing these tables.
The monitor system
tables return results for the SYSDBA user and for all users of the database
user class DBA.
Non-authorized users receive the error message 100 – Row not
found.
The monitor system tables have the following structure:
|
DESCRIPTION |
CHAR(40) |
|
VALUE |
FIXED(20) |
Each row contains a counter value. The meaning of this value is in the DESCRIPTION column.
Monitor System Tables