RE: Number of SQL Captured in AWR: 30?
Date: Mon, 16 Mar 2009 21:17:27 -0400
I reviewed ML docs on altering TOPNSQL which indicated this setting to affect how many sql is captured per criteria. A DBA on this thred also pointed to a ML doc, but it was mostly for SP. I have not yet found any references as to where the actual thresholds are specified and it they can be altered for the awr. I guess the best answer is that the default sets up the max to be displayed. At a default value of 30, I saw a range of 140-160 in dba-hist-sqlstats per snap-id.
If for whatever reason, you want to capture all sql, specify 'all' when you take a snapshot.
From: Joel Wittenmyer <joel.wittenmyer_at_templarstable.com> Sent: Monday, March 16, 2009 4:27 PM
To: Oracle-L Group <oracle-l_at_freelists.org> Subject: Re: Number of SQL Captured in AWR: 30?
I believe that means 'up to 30 that violate the thresholds'.
> 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