User Tools

Site Tools


oracle:awr

Differences

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/17 08:43]
dodger ↷ Page moved from awr to oracle:awr
oracle:awr [2020/03/20 11:16] (current)
dodger [List AWR snapshots]
Line 1: Line 1:
 +====== [DOC] AWR ======
  
 ====== Configuration ====== ====== Configuration ======
Line 56: 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.1523954583.txt.gz · Last modified: 2018/04/17 08:43 by dodger