Re: AWR not capturing sql_id anymore

From: Stojan Veselinovski <stojan.veselinovski_at_gmail.com>
Date: Fri, 8 Feb 2013 12:08:43 +1100
Message-ID: <CALn1tDvHdcF2j2rmgkFSjf-BTiPszRFhvGin4v4JW52HSNhzEg_at_mail.gmail.com>

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_at_gmail.com> 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.
>

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

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