Results 1 to 2 of 2

Thread: Session id

  1. #1
    Join Date
    Dec 2001
    Posts
    80

    Unanswered: Session id

    How do I know my session idenifier (SID) of my current session?

  2. #2
    Join Date
    Feb 2004
    Location
    Dublin, Ireland
    Posts
    212
    v$mystat shows statistics from your current session. so this could be what you need:
    Code:
    SELECT sid FROM v$mystat WHERE rownum = 1;

Posting Permissions

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