Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBA_HIST_WR_CONTROL - TOPNSQL

ChewySep 4 2013 — edited Sep 6 2016

Hi Guys,

My TOPNSQL is set to default which i Believe is 30.

However I can't see 30 SQLs after i generate the AWR report - under SQL ordered by Elapsed Time.

I can only see 12 SQLs. Can advise? I'm sure there are more than 12 SQLs fired.

SQL> select * from DBA_HIST_WR_CONTROL;

DBID
----------
SNAP_INTERVAL
--------------------------------------------
RETENTION
--------------------------------------------
TOPNSQL
----------
2111272503
+00000 01:00:00.0
+00031 00:00:00.0
DEFAULT

This post has been answered by jgarry on Sep 4 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 2 2013

Added on Sep 4 2013

#general-database-discussions

10 comments

1,693 views