DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2008

    sqltext from sqlid

    How do we see sqltext using sqlid?I mean i cant see full sqltext...what parameter i need to set before executing below query...

    select sesion.sid,
    from gv$sqltext sqltext, gv$session sesion
    where sesion.sql_hash_value = sqltext.hash_value
    and sesion.sql_address = sqltext.address
    and sesion.username is not null
    order by sqltext.piece

  2. #2
    Join Date
    Apr 2006
    Check V$SQL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.