DBA Data[Home] [Help]

VIEW: SYS.DBA_HIST_IOSTAT_DETAIL

Source

View Text - Preformatted

select "SNAP_ID","DBID","INSTANCE_NUMBER","FUNCTION_ID","FUNCTION_NAME","FILETYPE_ID","FILETYPE_NAME","SMALL_READ_MEGABYTES","SMALL_WRITE_MEGABYTES","LARGE_READ_MEGABYTES","LARGE_WRITE_MEGABYTES","SMALL_READ_REQS","SMALL_WRITE_REQS","LARGE_READ_REQS","LARGE_WRITE_REQS","NUMBER_OF_WAITS","WAIT_TIME","CON_DBID","CON_ID" from INT$DBA_HIST_IOSTAT_DETAIL
View Text - HTML Formatted

SELECT "SNAP_ID"
, "DBID"
, "INSTANCE_NUMBER"
, "FUNCTION_ID"
, "FUNCTION_NAME"
, "FILETYPE_ID"
, "FILETYPE_NAME"
, "SMALL_READ_MEGABYTES"
, "SMALL_WRITE_MEGABYTES"
, "LARGE_READ_MEGABYTES"
, "LARGE_WRITE_MEGABYTES"
, "SMALL_READ_REQS"
, "SMALL_WRITE_REQS"
, "LARGE_READ_REQS"
, "LARGE_WRITE_REQS"
, "NUMBER_OF_WAITS"
, "WAIT_TIME"
, "CON_DBID"
, "CON_ID"
FROM INT$DBA_HIST_IOSTAT_DETAIL