Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2004
    Posts
    8

    Unanswered: Retrieve Current Session info

    A stupid question but do not know actually
    How to retrieve the info of current session?
    I know the v$session can get the session info.
    But I want the info of the this session thread only.

  2. #2
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Code:
    SELECT *
    FROM   v$session
    WHERE  audsid = SYS_CONTEXT('userenv','sessionid');

Posting Permissions

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