[Home] [Help] [Dependency Information]
Object Name: | WRH$_FILESTATXS_BL |
---|---|
Object Type: | TABLE |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Tablespace: | SYSAUX |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WRH$_FILESTATXS_BL_PK | NORMAL | UNIQUE | SYSAUX |
DBID
SNAP_ID INSTANCE_NUMBER FILE# CON_DBID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SNAP_ID | NUMBER | Yes | ||
DBID | NUMBER | Yes | ||
INSTANCE_NUMBER | NUMBER | Yes | ||
FILE# | NUMBER | Yes | ||
CREATION_CHANGE# | NUMBER | Yes | ||
PHYRDS | NUMBER | |||
PHYWRTS | NUMBER | |||
SINGLEBLKRDS | NUMBER | |||
READTIM | NUMBER | |||
WRITETIM | NUMBER | |||
SINGLEBLKRDTIM | NUMBER | |||
PHYBLKRD | NUMBER | |||
PHYBLKWRT | NUMBER | |||
WAIT_COUNT | NUMBER | |||
TIME | NUMBER | |||
CON_DBID | NUMBER | Yes | ||
OPTIMIZED_PHYBLKRD | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SNAP_ID
, DBID
, INSTANCE_NUMBER
, FILE#
, CREATION_CHANGE#
, PHYRDS
, PHYWRTS
, SINGLEBLKRDS
, READTIM
, WRITETIM
, SINGLEBLKRDTIM
, PHYBLKRD
, PHYBLKWRT
, WAIT_COUNT
, TIME
, CON_DBID
, OPTIMIZED_PHYBLKRD
FROM SYS.WRH$_FILESTATXS_BL;
SYS.WRH$_FILESTATXS_BL does not reference any database object
SYS.WRH$_FILESTATXS_BL is not referenced by any database object
|
|
|