DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: how to get full version of sql statement

Threaded View

  1. 08-11-2005, 04:10 AM #2
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    You cannot from statspack report .

    But you can get them if the queries are there still in the library cache then look at v$sqltext_with_newlines.

    You can also have a look at the stats$sqltext in perfstat schema

    regards
    Hrishy
    Last edited by hrishy; 08-12-2005 at 02:59 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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