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

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

Go to previous page
Previous
Go to next page
Next
View PDF

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 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