RE: FULL SQL Query Code in Statspack report
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 24 May 2004 12:46:11 -0400
Hmm....no Oracle version. No matter, my psychic ability tells
me you're on 9.2.0.4 on Solaris 8, what a coincidence, so am I!
See $ORACLE_HOME/rdbms/admin/sprepins.sql
look for 'num_rows_per_hash=3D5', adjust accordingly.
-Mark
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of VIVEK_SHARMA
Sent: Monday, May 24, 2004 12:35 PM
To: LazyDBA.com Discussion; oracle-l@xxxxxxxxxxxxx
Subject: FULL SQL Query Code in Statspack report
Folks
Is it possible to enable some parameter for getting the FULL SQL Query
Code in the Statspack report?
OR Does the respective HASH_VALUE of the incomplete SQL Query (from
Statspack) need to be manually searched in V$SQLTEXT for getting the
Complete Code?
Thanks
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
