User Tools

Site Tools



This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
oracle:awr [2018/04/27 08:35]
oracle:awr [2020/03/20 11:16]
dodger [List AWR snapshots]
Line 57: Line 57:
 ===== List AWR snapshots ===== ===== List AWR snapshots =====
 <code sql> <code sql>
-select snap_id, snap_level, to_char(begin_interval_time, 'dd/mm/yy hh24:mi:ss') begin+select  
 +  DBID,  
 +  snap_id,  
 +  snap_level,  
 +  to_char(begin_interval_time, 'dd/mm/yy hh24:mi:ss') begin
 from from
    dba_hist_snapshot    dba_hist_snapshot
oracle/awr.txt · Last modified: 2020/03/20 11:16 by dodger