There are two types of diagnostic table expressions in
:
- Diagnostic tables
- Tables that are like any other table in
. You can specify the
diagnostic table name anywhere a normal table name is allowed.
- Diagnostic table functions
- Functions that are like any other function in
. Diagnostic table
functions can accept zero or more arguments, depending on the table function
that you use. You must use the SQL-defined table function syntax to access these
functions.
The following table shows the types and names of the diagnostic table
expressions in .
System diagnostic table expressions provided by
<ph conref="../conrefs.dita#prod/productshortname"></ph>
This table lists the diagnostic table expressions and their types (either table or table function).
Diagnostic Table Expression
Type of Expression
SYSCS_DIAG.CONTAINED_ROLES
Table function
SYSCS_DIAG.ERROR_LOG_READER
Table function
SYSCS_DIAG.ERROR_MESSAGES
Table
SYSCS_DIAG.LOCK_TABLE
Table
SYSCS_DIAG.SPACE_TABLE
Table function
SYSCS_DIAG.STATEMENT_CACHE
Table
SYSCS_DIAG.STATEMENT_DURATION
Table function
SYSCS_DIAG.TRANSACTION_TABLE
Table
If you reference a diagnostic table in a DDL statement
or a compression procedure,
returns an
exception.