Re: Number of SQL Captured in AWR: 30?
- From: Dion Cho <ukja.dion@xxxxxxxxx>
- To: fmhabash@xxxxxxxxx
- Date: Mon, 16 Mar 2009 09:30:01 +0900
1. 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)
2. There are internal thresholds of being considered "top". Trivial queries
would not be captured.
Visit metalink note # 394937.1.
3. If the query was aged out between the snapshots, it would not be
captured.
4. There would be other many reasons of not being captured.
================================
Dion Cho - Oracle Performance Storyteller
http://dioncho.wordpress.com (english)
http://ukja.tistory.com (korean)
================================
On Sun, Mar 15, 2009 at 10:45 PM, FmHabash <fmhabash@xxxxxxxxx> 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
> else?
>
> Thanks
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
