RE: Number of SQL Captured in AWR: 30?
- From: FmHabash <fmhabash@xxxxxxxxx>
- To: <joel.wittenmyer@xxxxxxxxxxxxxxxxx>, Oracle-L Group <oracle-l@xxxxxxxxxxxxx>
- 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. 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