5.390 DBA_SSCR_CAPTURE

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

NUMBER

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(128)

NOT NULL

User name of captured session

SCHEMA_NAME

VARCHAR2(128)

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(128)

Directory object of capture files

CAPTURE_LOCATOR

RAW(64)

Locator of master capture file

CAPTURE_TIME

TIMESTAMP(6)

Timestamp of capture operation