[Home] [Help] [Dependency Information]
Object Name: | CDB_SSCR_RESTORE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Session state restore statistics in all containers
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 |
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;
SYS.CDB_SSCR_RESTORE does not reference any database object
SYS.CDB_SSCR_RESTORE is referenced by following:
|
|
|