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.

VIEW: SYS.INT$DBA_HIST_CELL_DISK_SUMMARY

Source

View Text - Preformatted


select cd.snap_id, cd.dbid, cd.cell_hash, cd.incarnation_num,
       cd.disk_id 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_sum/num_samples disk_utilization_avg,
       reads_sum/num_samples      reads_avg,
       read_mb_sum/num_samples    read_mb_avg,
       writes_sum/num_samples     writes_avg,
       write_mb_sum/num_samples   write_mb_avg,
       io_requests_sum/num_samples         io_requests_avg,
       io_mb_sum/num_samples      io_mb_avg,
       service_time_sum/num_samples service_time_avg,
       small_reads_sum/num_samples      small_reads_avg,
       small_writes_sum/num_samples     small_writes_avg,
       large_reads_sum/num_samples      large_reads_avg,
       large_writes_sum/num_samples     large_writes_avg,
       small_read_bytes_sum/num_samples   small_read_bytes_avg,
       small_write_bytes_sum/num_samples  small_write_bytes_avg,
       large_read_bytes_sum/num_samples   large_read_bytes_avg,
       large_write_bytes_sum/num_samples  large_write_bytes_avg,
       small_read_latency_sum/num_samples small_read_latency_avg,
       small_write_latency_sum/num_samples small_write_latency_avg,
       large_read_latency_sum/num_samples  large_read_latency_avg,
       large_write_latency_sum/num_samples large_write_latency_avg,
       app_io_requests_sum/num_samples app_io_requests_avg,
       app_io_bytes_sum/num_samples   app_io_bytes_avg,
       app_io_latency_sum/num_samples app_io_latency_avg,
       decode(cd.con_dbid, 0, cd.dbid, cd.con_dbid),
       0 con_id
  from wrh$_cell_disk_summary cd,
      (select distinct snap_id, dbid
         from DBA_HIST_SNAPSHOT)  sn
  where     sn.snap_id          = cd.snap_id
        and sn.dbid             = cd.dbid

View Text - HTML Formatted

SELECT CD.SNAP_ID
, CD.DBID
, CD.CELL_HASH
, CD.INCARNATION_NUM
, CD.DISK_ID 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_SUM/NUM_SAMPLES DISK_UTILIZATION_AVG
, READS_SUM/NUM_SAMPLES READS_AVG
, READ_MB_SUM/NUM_SAMPLES READ_MB_AVG
, WRITES_SUM/NUM_SAMPLES WRITES_AVG
, WRITE_MB_SUM/NUM_SAMPLES WRITE_MB_AVG
, IO_REQUESTS_SUM/NUM_SAMPLES IO_REQUESTS_AVG
, IO_MB_SUM/NUM_SAMPLES IO_MB_AVG
, SERVICE_TIME_SUM/NUM_SAMPLES SERVICE_TIME_AVG
, SMALL_READS_SUM/NUM_SAMPLES SMALL_READS_AVG
, SMALL_WRITES_SUM/NUM_SAMPLES SMALL_WRITES_AVG
, LARGE_READS_SUM/NUM_SAMPLES LARGE_READS_AVG
, LARGE_WRITES_SUM/NUM_SAMPLES LARGE_WRITES_AVG
, SMALL_READ_BYTES_SUM/NUM_SAMPLES SMALL_READ_BYTES_AVG
, SMALL_WRITE_BYTES_SUM/NUM_SAMPLES SMALL_WRITE_BYTES_AVG
, LARGE_READ_BYTES_SUM/NUM_SAMPLES LARGE_READ_BYTES_AVG
, LARGE_WRITE_BYTES_SUM/NUM_SAMPLES LARGE_WRITE_BYTES_AVG
, SMALL_READ_LATENCY_SUM/NUM_SAMPLES SMALL_READ_LATENCY_AVG
, SMALL_WRITE_LATENCY_SUM/NUM_SAMPLES SMALL_WRITE_LATENCY_AVG
, LARGE_READ_LATENCY_SUM/NUM_SAMPLES LARGE_READ_LATENCY_AVG
, LARGE_WRITE_LATENCY_SUM/NUM_SAMPLES LARGE_WRITE_LATENCY_AVG
, APP_IO_REQUESTS_SUM/NUM_SAMPLES APP_IO_REQUESTS_AVG
, APP_IO_BYTES_SUM/NUM_SAMPLES APP_IO_BYTES_AVG
, APP_IO_LATENCY_SUM/NUM_SAMPLES APP_IO_LATENCY_AVG
, DECODE(CD.CON_DBID
, 0
, CD.DBID
, CD.CON_DBID)
, 0 CON_ID
FROM WRH$_CELL_DISK_SUMMARY CD
, (SELECT DISTINCT SNAP_ID
, DBID
FROM DBA_HIST_SNAPSHOT) SN
WHERE SN.SNAP_ID = CD.SNAP_ID
AND SN.DBID = CD.DBID