Showing posts with label stats$snapshot. Show all posts
Showing posts with label stats$snapshot. Show all posts

Thursday, April 4, 2013

Important queries on snapshots

-- Show all the Available Snapshots
  SELECT s.snap_id "Snap ID",
         di.instance_name "Instance Name",
         di.host_name "Host Name",
         di.parallel "RAC Instance",
         TO_CHAR (s.startup_time, ' dd Mon "at" HH24