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

Thread: serial#

  1. 12-01-2000, 07:43 AM #1
    aracnid
    aracnid is offline Member
    Join Date
    Apr 2000
    Location
    roma
    Posts
    131
    Does anyone know what is the number order of serial# in the v$session?
    E.s if i have users whith serial# =1 (what does it mean? are incremental the numbers?)
    Reply With Quote Reply With Quote
  2. 12-01-2000, 09:18 AM #2
    Slaine
    Slaine is offline Junior Member
    Join Date
    Aug 2000
    Location
    York - England
    Posts
    33
    As far as I know it is a way to monitor that a user is active
    If serial# is incrementing then the user is busy, if it does not move then it is possible that the user is inactive.

    Cheers
    :p :p :p
    Reply With Quote Reply With Quote
  3. 12-01-2000, 12:10 PM #3
    pss
    pss is offline Member
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    Incorrect!
    It is another session identified. Serial# makes sense only for sessions with AUDSID<>0 (actual database sessions but not internal Oracle processes.)

    Good luck!
    Sergey.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width