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

VIEW: SYS.CDB_SSCR_RESTORE

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

Session state restore statistics in all containers

[View Source]

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

Sequence# 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) (11)
Timestamp of restore 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#
,      RESTORE_MODE
,      RESTORE_SCOPE
,      RESTORE_FORMAT
,      RESTORE_DIR
,      RESTORE_LOCATOR
,      RESTORE_TIME
,      CON_ID
FROM SYS.CDB_SSCR_RESTORE;

Dependencies

[top of page]

SYS.CDB_SSCR_RESTORE does not reference any database object

SYS.CDB_SSCR_RESTORE is referenced by following:

SchemaPUBLIC
SynonymCDB_SSCR_RESTORE