Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003
    Posts
    51

    Unanswered: How to find out sqltext ?

    Hi all,

    I know the SID of a process, how i can discover the sql text related to this SID ?

    Thanks

    Antonio Freitas

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SELECT * FROM V$OPEN_CURSOR WHERE SID = <sid_value>;
    will provide some visibility.
    For more complete visibility join V$SESSION with V$SQLTEXT

Posting Permissions

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