Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E17110-04
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF


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