OraFAQ Forum: Performance Tuning » how to get full version of sql statement

Home » RDBMS Server » Performance Tuning » how to get full version of sql statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to get full version of sql statement [message #132152]

Thu, 11 August 2005 02:13

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