DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_SSCR_CAPTURE

Object Details
Object Name: CDB_SSCR_CAPTURE
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Session state capture statistics in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
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# of captured session
USER_NAME VARCHAR2 (30) Yes User name of captured session
SCHEMA_NAME VARCHAR2 (30) Yes Schema name of captured session
SEQUENCE# NUMBER

Sequence# of capture operation
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) (11)
Timestamp of capture operation
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DB_NAME
,      INST_NAME
,      INST_ID
,      SESSION_ID
,      SESSION_SERIAL#
,      USER_NAME
,      SCHEMA_NAME
,      SEQUENCE#
,      CAPTURE_MODE
,      CAPTURE_SCOPE
,      CAPTURE_FORMAT
,      CAPTURE_DIR
,      CAPTURE_LOCATOR
,      CAPTURE_TIME
,      CON_ID
FROM SYS.CDB_SSCR_CAPTURE;

Dependencies

[top of page]

SYS.CDB_SSCR_CAPTURE does not reference any database object

SYS.CDB_SSCR_CAPTURE is referenced by following:

SchemaPUBLIC
SynonymCDB_SSCR_CAPTURE