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

Thread: sqltext from sqlid

  1. #1
    Join Date
    Dec 2008
    Posts
    3

    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,
    sql_text
    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
    Posts
    377
    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