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]

VIEW: SYS.INT$DBA_HIST_CELL_DISK_SUMMARY

Object Details

Object Name:	INT$DBA_HIST_CELL_DISK_SUMMARY
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Mandatory
SNAP_ID	NUMBER	Yes
DBID	NUMBER	Yes
CELL_HASH	NUMBER	Yes
INCARNATION_NUM	NUMBER	Yes
DISK_ID	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
DISK_UTILIZATION_AVG	NUMBER
READS_AVG	NUMBER
READ_MB_AVG	NUMBER
WRITES_AVG	NUMBER
WRITE_MB_AVG	NUMBER
IO_REQUESTS_AVG	NUMBER
IO_MB_AVG	NUMBER
SERVICE_TIME_AVG	NUMBER
SMALL_READS_AVG	NUMBER
SMALL_WRITES_AVG	NUMBER
LARGE_READS_AVG	NUMBER
LARGE_WRITES_AVG	NUMBER
SMALL_READ_BYTES_AVG	NUMBER
SMALL_WRITE_BYTES_AVG	NUMBER
LARGE_READ_BYTES_AVG	NUMBER
LARGE_WRITE_BYTES_AVG	NUMBER
SMALL_READ_LATENCY_AVG	NUMBER
SMALL_WRITE_LATENCY_AVG	NUMBER
LARGE_READ_LATENCY_AVG	NUMBER
LARGE_WRITE_LATENCY_AVG	NUMBER
APP_IO_REQUESTS_AVG	NUMBER
APP_IO_BYTES_AVG	NUMBER
APP_IO_LATENCY_AVG	NUMBER
CON_DBID	NUMBER
CON_ID	NUMBER

Query Text

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


SELECT SNAP_ID
,      DBID
,      CELL_HASH
,      INCARNATION_NUM
,      DISK_ID
,      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
,      DISK_UTILIZATION_AVG
,      READS_AVG
,      READ_MB_AVG
,      WRITES_AVG
,      WRITE_MB_AVG
,      IO_REQUESTS_AVG
,      IO_MB_AVG
,      SERVICE_TIME_AVG
,      SMALL_READS_AVG
,      SMALL_WRITES_AVG
,      LARGE_READS_AVG
,      LARGE_WRITES_AVG
,      SMALL_READ_BYTES_AVG
,      SMALL_WRITE_BYTES_AVG
,      LARGE_READ_BYTES_AVG
,      LARGE_WRITE_BYTES_AVG
,      SMALL_READ_LATENCY_AVG
,      SMALL_WRITE_LATENCY_AVG
,      LARGE_READ_LATENCY_AVG
,      LARGE_WRITE_LATENCY_AVG
,      APP_IO_REQUESTS_AVG
,      APP_IO_BYTES_AVG
,      APP_IO_LATENCY_AVG
,      CON_DBID
,      CON_ID
FROM SYS.INT$DBA_HIST_CELL_DISK_SUMMARY;

Dependencies

[top of page]

SYS.INT$DBA_HIST_CELL_DISK_SUMMARY references the following:

SYS: DBA_HIST_SNAPSHOT; WRH$_CELL_DISK_SUMMARY

SYS.INT$DBA_HIST_CELL_DISK_SUMMARY is referenced by following:

SYS: DBA_HIST_CELL_DISK_SUMMARY