Re: TopNsql and awr
From: Harmandeep Singh <singh.bedi_at_gmail.com>
Date: Wed, 4 Jul 2018 18:05:58 +0530
Message-ID: <CAEWC_QCqHc3wAkntqr+5_BDzEf3evRBb3Mf9GXTk2ptbF6mp-g_at_mail.gmail.com>
Date: Wed, 4 Jul 2018 18:05:58 +0530
Message-ID: <CAEWC_QCqHc3wAkntqr+5_BDzEf3evRBb3Mf9GXTk2ptbF6mp-g_at_mail.gmail.com>
Hi Venky,
In the Section of SQLs.. at end there is line which mentions "It captures x% of sqls ". It seems in your case 10 sqls are capturing more than 90% so Oracle will not show you the another 10 even if you set topnsql to 50
Hope it helps
Regards
Harman
On Tue, Jul 3, 2018 at 3:08 AM, V Raman <vraman4list_at_gmail.com> wrote:
> List,
>
> I adjusted the topnsql so when I query the dba_hist_wr_control i see 50.
> Hoping to capture more than the default top 10 SQLs. However, even after
> the setting I see only 10 SQLs listed in the AWR reports, in SQLs by
> elapsed time, by CPU, reads, etc. Am I missing something.
>
> We definitely had more than 10 SQLs that run in the 2 half hour awr sample
> periods.
>
> venky.
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jul 04 2018 - 14:35:58 CEST