Sunday, July 27, 2014

awr snap id listings

column begin_interval_time format a25
column end_interval_time format a25
SELECT dbid, snap_id, begin_interval_time, end_interval_time from dba_hist_snapshot order by begin_interval_time;


http://www-03.ibm.com/systems/tools/databaseinsight/
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to Trouble shoot Logfile_sync wait event

   First  Identify and break down LGWR wait events. Query wait events for LGWR. In this instance LGWR sid is 3 (and usually it is). select s...