DBA_SSCR_CAPTURE displays session state capture statistics.
| Column | Datatype | NULL | Description |
|---|---|---|---|
DB_NAME |
VARCHAR2(4000) |
Database name of captured session | |
INST_NAME |
VARCHAR2(4000) |
Instance name of captured session | |
INST_ID |
VARCHAR2(4000) |
Instance ID of captured session | |
SESSION_ID |
NUMBER |
Session ID of captured session | |
SESSION_SERIAL# |
NUMBER |
Session serial number of captured session | |
USER_NAME |
VARCHAR2(30) |
NOT NULL |
User name of captured session |
SCHEMA_NAME |
VARCHAR2(30) |
NOT NULL |
Schema name of captured session |
SEQUENCE# |
NUMBER |
Sequence number of captured session | |
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(30) |
Directory object of capture files | |
CAPTURE_LOCATOR |
RAW(64) |
Locator of master capture file | |
CAPTURE_TIME |
TIMESTAMP(6) |
Timestamp of capture operation |