TopNsql and awr
From: V Raman <vraman4list_at_gmail.com>
Date: Mon, 2 Jul 2018 16:38:55 -0500
Message-ID: <CAGAYmOCjawP+XeRVK6JxXPDKshr3um4MRdn61gLhHB3D_jD7uw_at_mail.gmail.com>
List,
Date: Mon, 2 Jul 2018 16:38:55 -0500
Message-ID: <CAGAYmOCjawP+XeRVK6JxXPDKshr3um4MRdn61gLhHB3D_jD7uw_at_mail.gmail.com>
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-l
Received on Mon Jul 02 2018 - 23:38:55 CEST