Re: AWR not capturing sql_id anymore
- From: Stojan Veselinovski <stojan.veselinovski@xxxxxxxxx>
- To: Hemant K Chitale <hemantkchitale@xxxxxxxxx>
- Date: Fri, 8 Feb 2013 12:08:43 +1100
This sql_id is pretty much the heart of the solution and is always at
the top of the tree in terms of cpu, elapsed time and executions.
SQL> select * from (
2 select sql_id from v$sql order by elapsed_time desc nulls last
3 )
4 where rownum = 1;
SQL_ID
---------------------------------------
5c53m84fjcz5p
I have increased the top n to be 100 without any luck.
Stojan.
On Fri, Feb 8, 2013 at 11:37 AM, Hemant K Chitale
<hemantkchitale@xxxxxxxxx> wrote:
> AWR csptures the Top N SQLs where N may be 30. This SQL probably doesn't
> figure in the top 30 for each snapshot. You can modify AWR settings to
> modify the N to a higher value.
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
