SELECT
  inst_id,                                 -- INST_ID NUMBER
  total_size,                              -- TOTAL_SIZE NUMBER
  fixed_size,                              -- FIXED_SIZE NUMBER
  sampling_interval,                       -- SAMPLING_INTERVAL NUMBER
  decode(                                  -- OLDEST_SAMPLE_ID NUMBER
    oldest_sample_id, 0, to_number(null), oldest_sample_id),
  decode(                                  -- OLDEST_SAMPLE_TIME TIMESTAMP(9)
    oldest_sample_id, 0, to_timestamp(null), oldest_sample_time),
  decode(                                  -- LATEST_SAMPLE_ID NUMBER
    latest_sample_id, 0, to_number(null), latest_sample_id),
  decode(                                  -- LATEST_SAMPLE_TIME TIMESTAMP(9)
    latest_sample_id, 0, to_timestamp(null), latest_sample_time),
  sample_count,                            -- SAMPLE_COUNT NUMBER
  sampled_bytes,                           -- SAMPLED_BYTES NUMBER
  sampler_elapsed_time,                    -- SAMPLER_ELAPSED_TIME NUMBER
  disk_filter_ratio,                       -- DISK_FILTER_RATIO NUMBER
  flushed_bytes,                           -- AWR_FLUSH_BYTES NUMBER
  flusher_elapsed_time,                    -- AWR_FLUSH_ELAPSED_TIME NUMBER
  total_flusher_count,                     -- AWR_FLUSH_COUNT NUMBER
  emergency_flusher_count                  -- AWR_FLUSH_EMERGENCY_COUNT NUMBER
FROM
  x$kewam