|
-
how to get full version of sql statement
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..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|