RE: Number of SQL Captured in AWR: 30?

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.

Thanks 


-----Original Message-----
From: Joel Wittenmyer <joel.wittenmyer@xxxxxxxxxxxxxxxxx>
Sent: Monday, March 16, 2009 4:27 PM
To: Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
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
something else?
> 
> Thanks 
> --
> http://www.freelists.org/webpage/oracle-l
> 
> 
> 
> 

-- 

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l

Other related posts: