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 [2016/04/04 15:43]
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 ===== ===== List AWR snapshots =====
Line 59: Line 62:
 order by 1; order by 1;
 </code> </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