eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: SYS.WRH$_CELL_DISK_SUMMARY

Object Details

Object Name:	WRH$_CELL_DISK_SUMMARY
Object Type:	TABLE
Owner:	SYS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:
PCT Free:
PCT Used:

Primary Key: WRH$_CELL_DISK_SUMM_PK

DBID
SNAP_ID
CELL_HASH
INCARNATION_NUM
DISK_ID
CON_DBID

Indexes

Index	Type	Uniqueness	Tablespace	Column
WRH$_CELL_DISK_SUMM_PK	NORMAL	UNIQUE		DBID SNAP_ID CELL_HASH INCARNATION_NUM DISK_ID CON_DBID

Columns

Name	Datatype	Mandatory
SNAP_ID	NUMBER	Yes
DBID	NUMBER	Yes
CELL_HASH	NUMBER	Yes
INCARNATION_NUM	NUMBER	Yes
DISK_ID	NUMBER	Yes
CON_DBID	NUMBER	Yes
NUM_SAMPLES	NUMBER
DISK_UTILIZATION_SUM	NUMBER
READS_SUM	NUMBER
READ_MB_SUM	NUMBER
WRITES_SUM	NUMBER
WRITE_MB_SUM	NUMBER
IO_REQUESTS_SUM	NUMBER
IO_MB_SUM	NUMBER
SERVICE_TIME_SUM	NUMBER
WAIT_TIME_SUM	NUMBER
SMALL_READS_SUM	NUMBER
SMALL_WRITES_SUM	NUMBER
LARGE_READS_SUM	NUMBER
LARGE_WRITES_SUM	NUMBER
SMALL_READ_BYTES_SUM	NUMBER
SMALL_WRITE_BYTES_SUM	NUMBER
LARGE_READ_BYTES_SUM	NUMBER
LARGE_WRITE_BYTES_SUM	NUMBER
SMALL_READ_LATENCY_SUM	NUMBER
SMALL_WRITE_LATENCY_SUM	NUMBER
LARGE_READ_LATENCY_SUM	NUMBER
LARGE_WRITE_LATENCY_SUM	NUMBER
APP_IO_REQUESTS_SUM	NUMBER
APP_IO_BYTES_SUM	NUMBER
APP_IO_LATENCY_SUM	NUMBER
DISK_UTILIZATION_SUMX2	NUMBER
READS_SUMX2	NUMBER
READ_MB_SUMX2	NUMBER
WRITES_SUMX2	NUMBER
WRITE_MB_SUMX2	NUMBER
IO_REQUESTS_SUMX2	NUMBER
IO_MB_SUMX2	NUMBER
SERVICE_TIME_SUMX2	NUMBER
WAIT_TIME_SUMX2	NUMBER
SMALL_READS_SUMX2	NUMBER
SMALL_WRITES_SUMX2	NUMBER
LARGE_READS_SUMX2	NUMBER
LARGE_WRITES_SUMX2	NUMBER
SMALL_READ_BYTES_SUMX2	NUMBER
SMALL_WRITE_BYTES_SUMX2	NUMBER
LARGE_READ_BYTES_SUMX2	NUMBER
LARGE_WRITE_BYTES_SUMX2	NUMBER
SMALL_READ_LATENCY_SUMX2	NUMBER
SMALL_WRITE_LATENCY_SUMX2	NUMBER
LARGE_READ_LATENCY_SUMX2	NUMBER
LARGE_WRITE_LATENCY_SUMX2	NUMBER
APP_IO_REQUESTS_SUMX2	NUMBER
APP_IO_BYTES_SUMX2	NUMBER
APP_IO_LATENCY_SUMX2	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SNAP_ID
,      DBID
,      CELL_HASH
,      INCARNATION_NUM
,      DISK_ID
,      CON_DBID
,      NUM_SAMPLES
,      DISK_UTILIZATION_SUM
,      READS_SUM
,      READ_MB_SUM
,      WRITES_SUM
,      WRITE_MB_SUM
,      IO_REQUESTS_SUM
,      IO_MB_SUM
,      SERVICE_TIME_SUM
,      WAIT_TIME_SUM
,      SMALL_READS_SUM
,      SMALL_WRITES_SUM
,      LARGE_READS_SUM
,      LARGE_WRITES_SUM
,      SMALL_READ_BYTES_SUM
,      SMALL_WRITE_BYTES_SUM
,      LARGE_READ_BYTES_SUM
,      LARGE_WRITE_BYTES_SUM
,      SMALL_READ_LATENCY_SUM
,      SMALL_WRITE_LATENCY_SUM
,      LARGE_READ_LATENCY_SUM
,      LARGE_WRITE_LATENCY_SUM
,      APP_IO_REQUESTS_SUM
,      APP_IO_BYTES_SUM
,      APP_IO_LATENCY_SUM
,      DISK_UTILIZATION_SUMX2
,      READS_SUMX2
,      READ_MB_SUMX2
,      WRITES_SUMX2
,      WRITE_MB_SUMX2
,      IO_REQUESTS_SUMX2
,      IO_MB_SUMX2
,      SERVICE_TIME_SUMX2
,      WAIT_TIME_SUMX2
,      SMALL_READS_SUMX2
,      SMALL_WRITES_SUMX2
,      LARGE_READS_SUMX2
,      LARGE_WRITES_SUMX2
,      SMALL_READ_BYTES_SUMX2
,      SMALL_WRITE_BYTES_SUMX2
,      LARGE_READ_BYTES_SUMX2
,      LARGE_WRITE_BYTES_SUMX2
,      SMALL_READ_LATENCY_SUMX2
,      SMALL_WRITE_LATENCY_SUMX2
,      LARGE_READ_LATENCY_SUMX2
,      LARGE_WRITE_LATENCY_SUMX2
,      APP_IO_REQUESTS_SUMX2
,      APP_IO_BYTES_SUMX2
,      APP_IO_LATENCY_SUMX2
FROM SYS.WRH$_CELL_DISK_SUMMARY;

Dependencies

[top of page]

SYS.WRH$_CELL_DISK_SUMMARY does not reference any database object

SYS.WRH$_CELL_DISK_SUMMARY is referenced by following:

SYS: INT$DBA_HIST_CELL_DISK_SUMMARY