1. The specification of the SQLMODE SQL-DB in the <connect statement> is still possible.
2. A <range spec> in the following format can be specified instead of a <constraint definition> in the <create table statement>:
<range spec> ::=
RANGE [NOT] BETWEEN <literal> AND <literal>
RANGE [NOT] IN (<value spec>,...)
If a <range spec> is specified for an optional column, the <constraint definition> defined by it implicitly contains the NULL value. If this effect is not desired, NOT NULL must be specified in addition to the <range spec>. If a <default spec> was specified in addition, the <default value> must satisfy the <range spec>.
3. Instead of the <isolation spec>, the specifications LOCK EXPLICIT, LOCK NORMAL, and LOCK IMPLICIT are allowed.
- LOCK EXPLICIT corresponds to ISOLATION LEVEL 0.
- LOCK NORMAL corresponds to ISOLATION LEVEL 15.
- LOCK IMPLICIT corresponds to ISOLATION LEVEL 2 with the restriction that no table SHARE locks are set during the execution of an <sql statement>.
4. The <sql statement>s CREATE LINK and DROP LINK are still available. In contrast to former versions, the <referential constraint name> (link name) must be unique together with the name of the referencing table , no longer with the name of the <referenced table>.
Function
defines existence conditions between the rows of two tables.
Format
<create link statement> ::=
CREATE LINK <referential constraint name>
FOREIGN KEY <referencing table>
(<referencing column>,...)
<references spec>
Syntax Rules
none
General Rules
1. Executing the <create link statement> has the same effect as defining a corresponding <referential constraint definition> in the <create table statement> or an <alter table statement> of the referencing table.
2. The same rules which are valid for a <referential constraint definition> apply to the <create link statement>.
3. The <referential constraint name> must be different from all existing <referential constraint name>s of the referencing table.
4. Each row R of the referencing table must satisfy one of the following conditions:
i) R is the matching row of the <referential constraint definition>.
ii) R contains the NULL value in one of the columns of the <referencing column>s.
iii) The <delete rule> defines ON DELETE SET DEFAULT and R contains the default value in all columns of the <referencing column> s.
Function
drops a <referential constraint definition> between two tables.
Format
<drop link statement> ::=
DROP LINK <referential constraint name>
REFERENCES <referenced table>
Syntax Rules
none
General Rules
1. The user must be the owner of one of the two tables linked by the <referential constraint definition>, and the user must have the REFERENCES privilege on the corresponding table.
2. The meta data of the specified <referential constraint definition> is dropped from the catalog.
3. As <referential constraint definition>s are required for the updatability of join view tables, dropping a <referential constraint definition> can have the effect that a view table based on the <referenced table> and the referencing table can no longer be updated.
4. The <sql statement>s for catalog and statistical information are still available. This chapter contains a list of the <query statement>s that, issued on the system tables, should be used to replace the <sql statement>s for catalog and statistical information.
Note that the names of tables, domains, users, etc., must be enclosed in single quotation marks. Names specified as <simple identifier>s must be specified in uppercase characters. Names specified as <special identifier>s are entered without enclosing <double quotes> in the desired combination of upper- and lowercases. If <double quotes> belong to the <special identifier>, they are not doubled on input.
In the following list, a distinction is made between examples of catalog information determining a set of objects (list) and examples determining the structure or definition of just one object (structure or definition).
The structure of the statistical information result tables frequently consisted of a row that contained a DESCRIPTION and the value belonging to this description. For some of these informative functions, system tables are provided now that contain the complete information in one row in appropriately named columns. In the following list, the attempt was made to specify a <query statement> that does not modify the structure of the result tables. As information coming from one row must be split into several rows, the <query statement> is quite complicated. If it is not necessary to keep the structure of the result tables used so far, the simplified formats of the <query statement>s should be used.
COLUMN
List
-------------------------------------------------------------------
SHOW COLUMN SELECT *
<owner>.<table name>. FROM DOMAIN.COLUMNS
<column name> WHERE owner = <owner>
AND tablename = <table name>
AND columnname = <column name>
-------------------------------------------------------------------
CONNECT PARAM
List
-------------------------------------------------------------------
SHOW CONNECT PARAM SELECT *
FROM DOMAIN.CONNECTPARAMETERS
-------------------------------------------------------------------
CONSTRAINT
List
-------------------------------------------------------------------
SHOW CONSTRAINT SELECT *
FROM DOMAIN.CONSTRAINTS
SHOW CONSTRAINT SELECT *
<owner>.<table name> FROM DOMAIN.CONSTRAINTS
WHERE owner LIKE <owner>
AND tablename LIKE <table name>
-------------------------------------------------------------------
Definition
-------------------------------------------------------------------
SHOW CHECK SELECT definition
<owner>.<table name>. FROM DOMAIN.CONSTRAINTS
<constraint name> WHERE owner LIKE <owner>
AND tablename LIKE <table name>
AND constraintname LIKE <constraint name>
-------------------------------------------------------------------
DBPROCEDURE
List
-------------------------------------------------------------------
SHOW DBPROCEDURE SELECT *
<owner>.<program name>. FROM DOMAIN.DBPROCEDURES
<procedure name> WHERE owner LIKE <owner>
AND programname LIKE <program name>
AND dbprocname LIKE <procedure name>
-------------------------------------------------------------------
Parameter
-------------------------------------------------------------------
SHOW PARAM DBPROC SELECT *
<owner>.<program name>. FROM DOMAIN.DBPROCPARAMS
<procedure name> WHERE owner = <owner>
AND programname = <program name>
AND dbprocname = <procedure name>
-------------------------------------------------------------------
DOMAIN
List
-------------------------------------------------------------------
SHOW DOMAIN SELECT *
FROM DOMAIN.DOMAINS
SHOW DOMAIN SELECT *
<domain name> FROM DOMAIN.DOMAINS
WHERE domainname LIKE <domain name>
-------------------------------------------------------------------
Definition
-------------------------------------------------------------------
SHOW DOMAINDEF SELECT definition
<domain name> FROM DOMAIN.DOMAINS
WHERE domainname = <domain name>
-------------------------------------------------------------------
Domain Constraint
-------------------------------------------------------------------
SHOW CHECK SELECT definition
<domain name> FROM DOMAIN.DOMAINCONSTRAINTS
WHERE domainname = <domain name>
-------------------------------------------------------------------
FOREIGN KEY
List
-------------------------------------------------------------------
SHOW FOREIGN KEY SELECT defowner owner,
deftablename tablename,
defcolumnname columnname,
defrefname refname,
refowner,
reftablename,
refcolumnname,
rule,
createdate "date",
createtime "time",
comment
FROM DOMAIN.FKC_REFS_COL
SHOW FOREIGN KEY SELECT defowner owner,
<owner>.<table name> deftablename tablename,
defcolumnname columnname,
defrefname refname,
refowner,
reftablename,
refcolumnname,
rule,
createdate "date",
createtime "time",
comment
FROM DOMAIN.FKC_REFS_COL
WHERE defowner = <owner>
AND deftablename LIKE <table name>
-------------------------------------------------------------------
INDEX
List
-------------------------------------------------------------------
SHOW INDEX SELECT defowner owner,
deftablename tablename,
defindexname indexname,
type,
refcolumnname columnname,
pos,
sort,
createdate "date",
createtime "time",
comment
FROM DOMAIN.IND_USES_COL
ORDER BY owner,
tablename,
indexname,
pos
SHOW INDEX SELECT defowner owner,
<owner>.<table name> deftablename tablename,
defindexname indexname,
type,
refcolumnname columnname,
pos,
sort,
createdate "date",
createtime "time",
comment
FROM DOMAIN.IND_USES_COL
WHERE defowner = <owner>
AND deftablename LIKE <table name>
ORDER BY owner,
tablename,
indexname,
pos
-------------------------------------------------------------------
MAPCHARSET
List
-------------------------------------------------------------------
SHOW MAPCHARSET SELECT *
FROM DOMAIN.MAPCHARSETS
SHOW MAPCHARSET SELECT *
<mapcharset name> FROM DOMAIN.MAPCHARSETS
WHERE mapcharsetname LIKE
<mapcharset name>
-------------------------------------------------------------------
PRIMARY KEY
List
-------------------------------------------------------------------
SHOW PRIMARY KEY OF SELECT *
<owner>.<table name> FROM DOMAIN.COLUMNS
WHERE owner = <owner>
AND tablename = <table name>
AND keypos IS NOT NULL
ORDER BY keypos
-------------------------------------------------------------------
PRIVILEGES
List
-------------------------------------------------------------------
SHOW PRIV GRANTED SELECT refowner owner,
TO <user name> reftablename tablename,
ON <owner>.<table name> refcolumnname columnname,
privileges,
defusername grantor
FROM DOMAIN.USR_USES_COL
WHERE defusername LIKE <user name>
AND refowner LIKE <owner>
AND reftablename LIKE <table name>
SHOW PRIV ON SELECT refowner owner,
<owner>.<table name> reftablename tablename,
refcolumnname columnname,
privileges,
defusername grantor
FROM DOMAIN.USR_USES_COL
WHERE defusername = USERGROUP
AND refowner LIKE <owner>
AND reftablename LIKE <table name>
-------------------------------------------------------------------
SERVERDB
List
-------------------------------------------------------------------
SHOW SERVERDB SELECT *
FROM DOMAIN.SERVERDBS
SHOW SERVERDB SELECT *
<serverdb name> FROM DOMAIN.SERVERDBS
WHERE serverdb LIKE <serverdb name>
-------------------------------------------------------------------
SYNONYM
List
-------------------------------------------------------------------
SHOW SYNONYM SELECT defsynonymname synonymname,
refowner owner,
reftablename tablename
FROM DOMAIN.SYN_REFS_TAB
SHOW SYNONYM SELECT defsynonymname synonymname,
<synonym name> refowner owner,
reftablename tablename
FROM DOMAIN.SYN_REFS_TAB
WHERE defsynonymname LIKE <synonym name>
-------------------------------------------------------------------
SYSDBA
List
-------------------------------------------------------------------
SHOW SYSDBA SELECT SYSDBA
FROM LOCALSYSDBA.DUAL
SHOW SYSDBA SELECT SYSDBA (<user name>)
OF <user name> FROM LOCALSYSDBA.DUAL
-------------------------------------------------------------------
TABLE
List
-------------------------------------------------------------------
SHOW TABLE SELECT *
FROM DOMAIN.TABLES
ORDER BY owner,tablename
SHOW TABLE SELECT *
<owner>.<table name> FROM DOMAIN.TABLES
WHERE owner LIKE <owner>
AND tablename LIKE <table name>
-------------------------------------------------------------------
Structure
-------------------------------------------------------------------
SHOW TABLEDEF SELECT *
<owner>.<table name> FROM DOMAIN.COLUMNS
WHERE owner = <owner>
AND tablename = <table name>
ORDER BY pos
-------------------------------------------------------------------
TERMCHARSET
List
-------------------------------------------------------------------
SHOW TERMCHARSET SELECT *
FROM DOMAIN.TERMCHARSETS
SHOW TERMCHARSET SELECT *
<termcharset name> FROM DOMAIN.TERMCHARSETS
WHERE termcharsetname LIKE
<termcharset name>
-------------------------------------------------------------------
TRIGGER
List
-------------------------------------------------------------------
SHOW TRIGGER SELECT *
FROM DOMAIN.TRIGGERS
SHOW TRIGGER SELECT *
<owner>.<table name>. FROM DOMAIN.TRIGGERS
<trigger name> WHERE owner LIKE <owner>
AND tablename LIKE <table name>
AND triggername LIKE <trigger name>
SHOW TRIGGER SELECT *
<trigger name> FROM DOMAIN.TRIGGERS
OF <owner>.<table name> WHERE owner LIKE <owner>
AND tablename LIKE <table name>
AND triggername LIKE <trigger name>
-------------------------------------------------------------------
Definition
-------------------------------------------------------------------
SHOW TRIGGERDEF SELECT definition
<trigger name> FROM DOMAIN.TRIGGERS
OF <owner>.<table name> WHERE owner = <owner>
AND tablename = <table name>
AND triggername = <trigger name>
-------------------------------------------------------------------
Parameter
-------------------------------------------------------------------
SHOW PARAM TRIGGER SELECT *
<trigger name> FROM DOMAIN.TRIGGERPARAMS
OF <owner>.<table name> WHERE owner = <owner>
AND tablename = <table name>
AND triggername = <trigger name>
-------------------------------------------------------------------
USER
List
-------------------------------------------------------------------
SHOW USER SELECT *
FROM DOMAIN.USERS
SHOW USER <user name> SELECT *
FROM DOMAIN.USERS
WHERE username LIKE <user name>
OR groupname LIKE <user name>
SHOW USER CURRENT SELECT *
FROM DOMAIN.USERS
WHERE ((username = ' '
AND groupname = USERGROUP)
OR username = USERGROUP)
-------------------------------------------------------------------
USER CONNECTED
List
-------------------------------------------------------------------
SHOW USER CONNECTED SELECT *
FROM DOMAIN.CONNECTEDUSERS
-------------------------------------------------------------------
VERSION
List
-------------------------------------------------------------------
SHOW VERSION SELECT *
FROM DOMAIN.VERSIONS
-------------------------------------------------------------------
VIEW
List
-------------------------------------------------------------------
SHOW TABLE SELECT *
FROM DOMAIN.VIEWS
ORDER BY owner,tablename
SHOW TABLE SELECT *
<owner>.<table name> FROM DOMAIN.VIEWS
WHERE owner LIKE <owner>
AND tablename LIKE <table name>
-------------------------------------------------------------------
Structure
-------------------------------------------------------------------
SHOW TABLEDEF SELECT *
<owner>.<table name> FROM DOMAIN.COLUMNS
WHERE owner = <owner>
AND tablename = <table name>
ORDER BY pos
-------------------------------------------------------------------
Definition
-------------------------------------------------------------------
SHOW VIEW SELECT definition
<owner>.<table name> FROM DOMAIN.VIEWDEFS
WHERE owner = <owner>
AND tablename = <table name>
-------------------------------------------------------------------
OPTIMIZE STATISTICS
List
-------------------------------------------------------------------
SHOW OPTIMIZE STATISTICS SELECT columnname,indexname,
<owner>.<table name> distinctvalues,pagecount,avglistlength
FROM FROM SYSDBA.OPTIMIZERSTATISTICS
WHERE owner = <owner>
AND tablename LIKE <table name>
-------------------------------------------------------------------
STATISTICS CONFIGURATION
List
-------------------------------------------------------------------
SHOW STATISTICS CONFIG SELECT SUBSTR(DESCRIPTION,1,40),
DECODE(CHAR_VALUE,NULL,
LFILL(CHR(NUMERIC_VALUE),' ',12),
SUBSTR(CHAR_VALUE,1,40))
FROM SYSDBA.CONFIGURATION
-------------------------------------------------------------------
STATISTICS DEVSPACE
List
-------------------------------------------------------------------
SHOW STATISTICS DEVSPACE SELECT SUBSTR('PAGES',1,40),
<devspace name> FIXED(DEVSPACESIZE,12)
FROM SYSDBA.DATADEVSPACES
WHERE devspacename LIKE <devspace name>
UNION ALL
SELECT 'LAST DATA PAGE NO',
MAXDATAPAGENO
FROM SYSDBA.DATADEVSPACES
WHERE devspacename LIKE <devspace name>
UNION ALL
SELECT 'USED PERM PAGES',
USEDPERMPAGES
FROM SYSDBA.DATADEVSPACES
WHERE devspacename LIKE <devspace name>
UNION ALL
SELECT 'USED PERM PAGES (%)',
PCTUSEDPERM
FROM SYSDBA.DATADEVSPACES
WHERE devspacename LIKE <devspace name>
UNION ALL
SELECT 'USED TEMP PAGES',
USEDTMPPAGES
FROM SYSDBA.DATADEVSPACES
WHERE devspacename LIKE <devspace name>
UNION ALL
SELECT 'USED TEMP PAGES (%)',
PCTUSEDTMP
FROM SYSDBA.DATADEVSPACES
WHERE devspacename LIKE <devspace name>
UNION ALL
SELECT 'UNUSED PAGES',
UNUSEDPAGES
FROM SYSDBA.DATADEVSPACES
WHERE devspacename LIKE <devspace name>
UNION ALL
SELECT 'UNUSED PAGES (%)',
PCTUNUSED
FROM SYSDBA.DATADEVSPACES
WHERE devspacename LIKE <devspace name>
SHOW STATISTICS DEVSPACE SELECT DEVSPACESIZE,MAXDATAPAGENO,
<devspace name> USEDPERMPAGES,PCTUSEDPERM,
USEDTMPPAGES,PCTUSEDTMP,
UNUSEDPAGES,PCTUNUSED
FROM SYSDBA.DATADEVSPACES
WHERE devspacename LIKE <devspace name>
-------------------------------------------------------------------
<devspace name> ::=
STATISTICS INDEX
List
-------------------------------------------------------------------
SHOW STATISTICS INDEX SELECT SUBSTR(DESCRIPTION,1,40),
<owner>.<table name>. DECODE(CHAR_VALUE,NULL,
<column name> LFILL(CHR(NUMERIC_VALUE),' ',12),
SUBSTR(CHAR_VALUE,1,40))
FROM SYSDBA.INDEXSTATISTICS
WHERE owner = <owner>
AND tablename LIKE <table name>
AND columnname LIKE <column name>
SHOW STATISTICS INDEX SELECT SUBSTR(DESCRIPTION,1,40),
<index name> OF DECODE(CHAR_VALUE,NULL,
<owner>.<table name> LFILL(CHR(NUMERIC_VALUE),' ',12),
SUBSTR(CHAR_VALUE,1,40))
FROM SYSDBA.INDEXSTATISTICS
WHERE owner = <owner>
AND tablename LIKE <table name>
AND indexname LIKE <index name>
-------------------------------------------------------------------
STATISTICS LOCK
List
-------------------------------------------------------------------
SHOW STATISTICS LOCK SELECT
OWNER,TABLENAME,ROWIDLENGTH,ROWIDHEX,
DECODE(LOCKMODE,NULL,LOCKREQUESTMODE,
LOCKMODE) LOCKMODE,PENDINGLOCK,
SERVERDBNO,SESSION,TRANSACTION,
DECODE(REMOTEUSER,'YES','<remote>',
USERNAME) USERNAME,TERMID,PROCESS
FROM SYSDBA.LOCKSTATISTICS
SHOW STATISTICS SELECT *
LOCK CONFIG FROM SYSDBA.LOCKLISTSTATISTICS
SHOW STATISTICS SELECT DISTINCT OWNER,TABLENAME,
LOCK TABLE DECODE(LOCKMODE,NULL,LOCKREQUESTMODE,
<owner>.<table name> LOCKMODE) LOCKMODE,PENDINGLOCK,
SERVERDBNO,SESSION,TRANSACTION,
DECODE(REMOTEUSER,'YES','<remote>',
USERNAME) USERNAME,TERMID,PROCESS
FROM SYSDBA.LOCKSTATISTICS
WHERE owner LIKE <owner>
AND tablename LIKE <table name>
SHOW STATISTICS SELECT SERVERDBNO,SESSION,TRANSACTION,
LOCK USER DECODE(REMOTEUSER,'YES','<remote>',
USERNAME) USERNAME,TERMID,PROCESS,
DECODE(LOCKMODE,NULL,LOCKREQUESTMODE,
LOCKMODE) LOCKMODE,PENDINGLOCK
FROM SYSDBA.TRANSACTIONS
-------------------------------------------------------------------
STATISTICS LOG
List
-------------------------------------------------------------------
SHOW STATISTICS LOG SELECT SUBSTR(DESCRIPTION,1,40),
SUBSTR(CHAR_VALUE,1,12)
FROM SYSDBA.CONFIGURATION
WHERE DESCRIPTION = 'LOG MODE'
UNION ALL
SELECT 'LOG PAGES',
LFILL(CHR(LOGSIZE),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED LOG PAGES',
LFILL(CHR(USEDLOGPAGES),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED LOG PAGES (%)',
LFILL(CHR(PCTUSEDLOGPAGES),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'UNUSED LOG PAGES',
LFILL(CHR(UNUSEDLOGPAGES),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'UNUSED LOG PAGES (%)',
LFILL(CHR(PCTUNUSEDLOGPAGES),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'RESERVED LOG PAGES',
LFILL(CHR(RESERVEDLOGPAGES),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'LOG SEGMENT SIZE',
LFILL(CHR(LOGSEGMENTSIZE),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'LOG SEGMENTS COMPLETED',
LFILL(CHR(COMPLETESEGMENTS),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'SAVEPOINTS',
LFILL(CHR(SAVEPOINTS),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'CHECKPOINTS',
LFILL(CHR(CHECKPOINTS),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'LOG PAGES PER SAVEPOINT',
LFILL(CHR(PAGESPERSAVEPOINT),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'LOG PAGES PER CHECKPOINT',
LFILL(CHR(PAGESPERCHECKPOINT),' ',12)
FROM SYSDBA.SERVERDBSTATISTICS
SHOW STATISTICS LOG SELECT
CHAR_VALUE,LOGSIZE,USEDLOGPAGES,
PCTUSEDLOGPAGES,UNUSEDLOGPAGES,
PCTUNUSEDLOGPAGES,RESERVEDLOGPAGES,
LOGSEGMENTSIZE,COMPLETESEGMENTS,
SAVEPOINTS,CHECKPOINTS,
PAGESPERSAVEPOINT,PAGESPERCHECKPOINT
FROM SYSDBA.SERVERDBSTATISTICS,
SYSDBA.CONFIGURATION
WHERE DESCRIPTION = 'LOG MODE'
-------------------------------------------------------------------
STATISTICS MAPCHAR SET
List
-------------------------------------------------------------------
SHOW STATISTICS SELECT INTERN,"map code","map character"
MAPCHAR SET FROM DOMAIN.MAPCHARSETS
<mapcharset name> WHERE mapcharsetname LIKE
<mapcharset name>
-------------------------------------------------------------------
STATISTICS SERVERDB
List
-------------------------------------------------------------------
SHOW STATISTICS SERVERDB SELECT SUBSTR('PAGES',1,40),
FIXED(SERVERDBSIZE,12)
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'MAX DATA PAGE NO',
MAXDATAPAGENO
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED PERM PAGES',
USEDPERMPAGES
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED PERM PAGES (%)',
PCTUSEDPERM
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED TEMP PAGES',
USEDTMPPAGES
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'USED TEMP PAGES (%)',
PCTUSEDTMP
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'UNUSED PAGES',
UNUSEDPAGES
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'UNUSED PAGES (%)',
PCTUNUSED
FROM SYSDBA.SERVERDBSTATISTICS
UNION ALL
SELECT 'UPDATED PERM PAGES',
UPDATEDPERMPAGES
FROM SYSDBA.SERVERDBSTATISTICS
SHOW STATISTICS SERVERDB SELECT SERVERDBSIZE,MAXDATAPAGENO,
USEDPERMPAGES,PCTUSEDPERM,
USEDTMPPAGES,PCTUSEDTMP,
UNUSEDPAGES,PCTUNUSED,
UPDATEDPERMPAGES
FROM SYSDBA.SERVERDBSTATISTICS
-------------------------------------------------------------------
STATISTICS TABLE
List
-------------------------------------------------------------------
SHOW STATISTICS TABLE SELECT SUBSTR(DESCRIPTION,1,40),
<owner>.<table name> DECODE(CHAR_VALUE,NULL,
LFILL(CHR(NUMERIC_VALUE),' ',12),
SUBSTR(CHAR_VALUE,1,40))
FROM SYSDBA.TABLESTATISTICS
WHERE owner = <owner>
AND tablename LIKE <table name>
-------------------------------------------------------------------
STATISTICS TERMCHAR SET
List
-------------------------------------------------------------------
SHOW STATISTICS SELECT *
TERMCHAR SET FROM DOMAIN.TERMCHARSETS
SHOW STATISTICS SELECT *
TERMCHAR SET FROM DOMAIN.TERMCHARSETS
<termcharset name> WHERE termcharsetname LIKE
<termcharset name>
-------------------------------------------------------------------
STATISTICS USER
List
-------------------------------------------------------------------
SHOW STATISTICS USER SELECT *
<user name> FROM SYSDBA.USERSTATISTICS
WHERE username LIKE <user name>
-------------------------------------------------------------------
MONITOR
List
-------------------------------------------------------------------
SHOW MONITOR ALL SELECT *
FROM SYSDBA.MONITOR
SHOW MONITOR CACHES SELECT *
FROM SYSDBA.MONITOR_CACHES
SHOW MONITOR DBPROC SELECT *
FROM SYSDBA.MONITOR_DBPROC
SHOW MONITOR LOAD SELECT *
FROM SYSDBA.MONITOR_LOAD
SHOW MONITOR LOCK SELECT *
FROM SYSDBA.MONITOR_LOCK
SHOW MONITOR LOG SELECT *
FROM SYSDBA.MONITOR_LOG
SHOW MONITOR PAGES SELECT *
FROM SYSDBA.MONITOR_PAGES
SHOW MONITOR ROW SELECT *
FROM SYSDBA.MONITOR_ROW
SHOW MONITOR SERVERDB SELECT *
FROM SYSDBA.MONITOR_SERVERDB
SHOW MONITOR TRANSACTION SELECT *
FROM SYSDBA.MONITOR_TRANS
SHOW MONITOR VTRACE SELECT *
FROM SYSDBA.MONITOR_VTRACE
-------------------------------------------------------------------