[Home] [Help] [Dependency Information]
Object Name: | WRH$_LOG |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WRH$_LOG_PK | NORMAL | UNIQUE | SYSAUX |
DBID
SNAP_ID INSTANCE_NUMBER GROUP# THREAD# SEQUENCE# CON_DBID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
GROUP# | NUMBER | Yes | ||
THREAD# | NUMBER | Yes | ||
SEQUENCE# | NUMBER | Yes | ||
BYTES | NUMBER | |||
MEMBERS | NUMBER | |||
ARCHIVED | VARCHAR2 | (3) | ||
STATUS | VARCHAR2 | (16) | ||
FIRST_CHANGE# | NUMBER | |||
FIRST_TIME | DATE | |||
CON_DBID | NUMBER | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, GROUP#
, THREAD#
, SEQUENCE#
, BYTES
, MEMBERS
, ARCHIVED
, STATUS
, FIRST_CHANGE#
, FIRST_TIME
, CON_DBID
FROM SYS.WRH$_LOG;
SYS.WRH$_LOG does not reference any database object
SYS.WRH$_LOG is referenced by following:
|
|
|