Re: Number of SQL Captured in AWR: 30?

From: Dion Cho <>
Date: Mon, 16 Mar 2009 09:30:01 +0900
Message-ID: <>

  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 (english) (korean)

On Sun, Mar 15, 2009 at 10:45 PM, FmHabash <> 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
> --

Received on Sun Mar 15 2009 - 19:30:01 CDT

Original text of this message