DBA Data[Home] [Help]

VIEW: SYS.GV_$ASH_INFO

Source

View Text - Preformatted

select "INST_ID","TOTAL_SIZE","FIXED_SIZE","SAMPLING_INTERVAL","OLDEST_SAMPLE_ID","OLDEST_SAMPLE_TIME","LATEST_SAMPLE_ID","LATEST_SAMPLE_TIME","SAMPLE_COUNT","DROPPED_SAMPLE_COUNT","SAMPLED_BYTES","SAMPLER_ELAPSED_TIME","DISK_FILTER_RATIO","AWR_FLUSH_BYTES","AWR_FLUSH_ELAPSED_TIME","AWR_FLUSH_COUNT","AWR_FLUSH_EMERGENCY_COUNT","CON_ID" from gv$ash_info
View Text - HTML Formatted

SELECT "INST_ID"
, "TOTAL_SIZE"
, "FIXED_SIZE"
, "SAMPLING_INTERVAL"
, "OLDEST_SAMPLE_ID"
, "OLDEST_SAMPLE_TIME"
, "LATEST_SAMPLE_ID"
, "LATEST_SAMPLE_TIME"
, "SAMPLE_COUNT"
, "DROPPED_SAMPLE_COUNT"
, "SAMPLED_BYTES"
, "SAMPLER_ELAPSED_TIME"
, "DISK_FILTER_RATIO"
, "AWR_FLUSH_BYTES"
, "AWR_FLUSH_ELAPSED_TIME"
, "AWR_FLUSH_COUNT"
, "AWR_FLUSH_EMERGENCY_COUNT"
, "CON_ID"
FROM GV$ASH_INFO