[Home] [Help] [Dependency Information]
Object Name: | CDB_SSCR_CAPTURE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Session state capture statistics in all containers
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DB_NAME | VARCHAR2 | (4000) | Database name of captured session | |
INST_NAME | VARCHAR2 | (4000) | Instance name of captured session | |
INST_ID | NUMBER | Instance id of captured session | ||
SESSION_ID | NUMBER | Session ID of captured session | ||
SESSION_SERIAL# | NUMBER | Session serial# of captured session | ||
USER_NAME | VARCHAR2 | (30) | Yes | User name of captured session |
SCHEMA_NAME | VARCHAR2 | (30) | Yes | Schema name of captured session |
SEQUENCE# | NUMBER | Sequence# of capture operation | ||
CAPTURE_MODE | VARCHAR2 | (7) | Mode of capture operation | |
CAPTURE_SCOPE | VARCHAR2 | (7) | Scope of capture operation | |
CAPTURE_FORMAT | VARCHAR2 | (9) | Format of capture files | |
CAPTURE_DIR | VARCHAR2 | (128) | Directory object of capture files | |
CAPTURE_LOCATOR | RAW | (64) | Locator of master capture file | |
CAPTURE_TIME | TIMESTAMP(6) | (11) | Timestamp of capture operation | |
CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT DB_NAME
, INST_NAME
, INST_ID
, SESSION_ID
, SESSION_SERIAL#
, USER_NAME
, SCHEMA_NAME
, SEQUENCE#
, CAPTURE_MODE
, CAPTURE_SCOPE
, CAPTURE_FORMAT
, CAPTURE_DIR
, CAPTURE_LOCATOR
, CAPTURE_TIME
, CON_ID
FROM SYS.CDB_SSCR_CAPTURE;
SYS.CDB_SSCR_CAPTURE does not reference any database object
SYS.CDB_SSCR_CAPTURE is referenced by following:
|
|
|