RE: FULL SQL Query Code in Statspack report

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Mon, 24 May 2004 12:46:11 -0400
Message-ID: <4C9B6FDA0B06FE4DAF5918BBF0AD82CF03B45530@bosmail00.bos.il.pqe>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of VIVEK_SHARMA Sent: Monday, May 24, 2004 12:35 PM
To: LazyDBA.com Discussion; oracle-l_at_freelists.org 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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/

FAQ is at http://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_at_freelists.org

put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Mon May 24 2004 - 11:43:10 CDT