Home » RDBMS Server » Performance Tuning » how to get full version of sql statement
icon2.gif  how to get full version of sql statement [message #132152] Thu, 11 August 2005 02:13 Go to next message
rgopani
Messages: 15
Registered: June 2005
Location: rupesh_gopani@yahoo.com
Junior Member

Hi,
I m using statspack for tuning sql statements.
here I can get bed sql queries which I have to tune,but I get only a partial version of sql statement and hash value.Now if I want to extract full version from hash value how can i get?Dont say v$sql or v$sqlarea,because here also i m getting only a part version as it stores only 1000 character (varchar2(1000))

how can i get full version of this sql statement so that i can tune the same..

Re: how to get full version of sql statement [message #132216 is a reply to message #132152] Thu, 11 August 2005 06:52 Go to previous message
Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
enable tracing with level 8 or level 12 ( if you use bind variables)
Previous Topic: Full Table Scan
Next Topic: How to make this query run faster using PL/SQL update and insert
Goto Forum:
  


Current Time: Fri Dec 09 12:46:54 CST 2022