DBA_SSCR_RESTORE

DBA_SSCR_RESTORE displays session state restore statistics.


Column Datatype NULL Description

DB_NAME

VARCHAR2(4000)

 

Database name of restored session

INST_NAME

VARCHAR2(4000)

 

Instance name of restored session

INST_ID

NUMBER

 

Instance ID of restored session

SESSION_ID

NUMBER

 

Session ID of restored session

SESSION_SERIAL#

NUMBER

 

Session serial number of restored session

USER_NAME

VARCHAR2(128)

NOT NULL

User name of restored session

SCHEMA_NAME

VARCHAR2(128)

NOT NULL

Schema name of restored session

SEQUENCE#

NUMBER

 

Sequence number of restore operation

RESTORE_MODE

VARCHAR2(7)

 

Mode of restore operation

RESTORE_SCOPE

VARCHAR2(7)

 

Scope of restore operation

RESTORE_FORMAT

VARCHAR2(9)

 

Format of restore files

RESTORE_DIR

VARCHAR2(128)

 

Directory object of restore files

RESTORE_LOCATOR

RAW(64)

 

Locator of master restore file

RESTORE_TIME

TIMESTAMP(6)

 

Timestamp of restore operation