Re: AWR not capturing sql_id anymore

From: Stojan Veselinovski <>
Date: Fri, 8 Feb 2013 12:08:43 +1100
Message-ID: <>

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;



I have increased the top n to be 100 without any luck.


On Fri, Feb 8, 2013 at 11:37 AM, Hemant K Chitale <> 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.

Received on Fri Feb 08 2013 - 02:08:43 CET

Original text of this message