RE: Missing SQL in DBA_HIST_SQLSTAT

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Tue, 2 Nov 2010 09:55:56 -0700
Message-ID: <64BAF54438380142A0BF94A23224A31E11AEFCE903_at_ONEWS06.oneneck.corp>

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.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 02 2010 - 11:55:56 CDT