Home -> Mailing Lists -> Oracle-L -> TopNsql and awr

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,



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












Original text of this message