DBA_SSCR_CAPTURE

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 primary capture file
`CAPTURE_TIME`	`TIMESTAMP(6)`		Timestamp of capture operation