select "FUNCTION_ID","FUNCTION_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_ID" from v$iostat_function
SELECT "FUNCTION_ID"
, "FUNCTION_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_ID"
FROM V$IOSTAT_FUNCTION
|
|
|