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
Last revision Both sides next revision
oracle:awr [2015/01/26 12:10]
dodger
oracle:awr [2019/07/18 07:17]
127.0.0.1 external edit
Line 1: Line 1:
 +====== [DOC] AWR ======
  
-====== AWR ======+====== Configuration ======
 ===== Actual config ===== ===== Actual config =====
  
Line 51: Line 52:
 / /
 </code> </code>
 +
 +====== Basic queries ======
 +
 +===== List AWR snapshots =====
 +<code sql>
 +select snap_id, snap_level, to_char(begin_interval_time, 'dd/mm/yy hh24:mi:ss') begin
 +from
 +   dba_hist_snapshot
 +order by 1;
 +</code>
 +
 +===== View SQL_TEXT of selected SQL_ID =====
 +<code sql>
 +select SQL_TEXT from WRH$_SQLTEXT where SQL_ID='<SQL_ID>';
 +</code>
 +
 +
 +
 +
oracle/awr.txt · Last modified: 2020/03/20 11:16 by dodger