5.391 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