[Home] [Help] [Dependency Information]
Object Name: | MGMT_SNAPSHOT |
---|---|
Object Type: | TABLE |
Owner: | DBSNMP |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSTEM |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
INST_NUM_KEY | NORMAL | UNIQUE | SYSTEM | INSTANCE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INSTANCE_NUMBER | NUMBER | Yes | ||
SNAP_ID | NUMBER | Yes | ||
CAPTURE_TIME | DATE | Yes | ||
DB_TIME | NUMBER | |||
CPU_TIME | NUMBER | |||
APPLICATION_WAIT_TIME | NUMBER | |||
CLUSTER_WAIT_TIME | NUMBER | |||
USER_IO_WAIT_TIME | NUMBER | |||
CONCURRENCY_WAIT_TIME | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INSTANCE_NUMBER
, SNAP_ID
, CAPTURE_TIME
, DB_TIME
, CPU_TIME
, APPLICATION_WAIT_TIME
, CLUSTER_WAIT_TIME
, USER_IO_WAIT_TIME
, CONCURRENCY_WAIT_TIME
FROM DBSNMP.MGMT_SNAPSHOT;
DBSNMP.MGMT_SNAPSHOT does not reference any database object
DBSNMP.MGMT_SNAPSHOT is referenced by following:
|
|
|