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..

Report message to a moderator

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: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
enable tracing with level 8 or level 12 ( if you use bind variables)

Report message to a moderator

Previous Topic: Full Table Scan
Next Topic: How to make this query run faster using PL/SQL update and insert
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Nov 03 19:06:36 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.