RE: Missing SQL in DBA_HIST_SQLSTAT

  • From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
  • To: "Dave.Herring@xxxxxxxxxx" <Dave.Herring@xxxxxxxxxx>, ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 2 Nov 2010 09:55:56 -0700

Dave,

Do you have 'DEFAULT' for topnsql in the following query:

SQL> select topnsql from dba_hist_wr_control;

TOPNSQL
----------
DEFAULT

If so, then it only captures the top 30 according to the documentation below.  
Maybe you should try changing it from DEFAULT to MAXIMUM if you haven't tried 
that yet.

http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_wkrpos.htm#sthref8044

"DEFAULT will revert the system back to the default behavior of Top 30 for 
statistics level TYPICAL and Top 100 for statistics level ALL. Specifying 
MAXIMUM will cause the system to capture the complete set of SQL in the cursor 
cache. Specifying the number N is equivalent to setting the Top N SQL with the 
NUMBER type. Specifying NULL for this argument will keep the current setting."

Regards,
Brandon



Privileged/Confidential Information may be contained in this message or 
attachments hereto. Please advise immediately if you or your employer do not 
consent to Internet email for messages of this kind. Opinions, conclusions and 
other information in this message that do not relate to the official business 
of this company shall be understood as neither given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l


Other related posts: