Re: Number of SQL Captured in AWR: 30?
Date: Mon, 16 Mar 2009 09:30:01 +0900
- FIY, the 30 is per criteria, not per instance. The criterias are: Elapsed Time (ms) CPU Time (ms) Executions Buffer Gets Disk Reads Parse Calls Rows User I/O Wait Time (ms) Cluster Wait Time (ms) Application Wait Time (ms) Concurrency Wait Time (ms) Invalidations Version Count Sharable Mem(KB)
- There are internal thresholds of being considered "top". Trivial queries would not be captured. Visit metalink note # 394937.1.
- If the query was aged out between the snapshots, it would not be captured.
- There would be other many reasons of not being captured.
Dion Cho - Oracle Performance Storyteller
On Sun, Mar 15, 2009 at 10:45 PM, FmHabash <fmhabash_at_gmail.com> wrote:
> The awr docs indicate it defaults to be 30, but I do not see this much
> listed in any of my awr reports.
> Are there 2 settings for capturing and displaying or am I missing something