sys$users in v$session
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: sys$users in v$session

  1. #1
    Join Date
    Feb 2001
    Posts
    128

    sys$users in v$session

    Hi,

    There's a column called service_name in v$session which has three distinct values. 1. DB name 2. sys$background 3.sys$users

    I have some users with "sys$users" as the service name. I'm not exactly sure how this gets created. I checked for some doc's and did not find anything that clearly explains that.

    Can someone tell me or point me to some doc's that tell me how these sessions(with service_name sys$users) get created and how they are supposed to get cleaned up. I have sessions from past two days which are inactive and with service_name sys$users.

    Thanks in advance
    Jay

  2. #2
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Service name SYS$USERS and SYS$background created by oracle, and you have no control over that.

    SYS$USERS - default service given to a user who connect locally
    SYS$BACKGROUND - Service for all the background processes

    User defined service name will be assigned to sessions, those who are connecting thru that service name.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  3. #3
    Join Date
    Jan 2009
    Posts
    3

    Killing sys$user sessions..

    Hi ,

    can anyone please tell me if we can kill sys$user or sys$background sessions?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    you can kill any session - but if you kill a background session your database is going to go down

  5. #5
    Join Date
    Jan 2009
    Posts
    3
    Hi Davey,

    would there be any negative impact on database if we kill sys$user sessions only?

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    not on the database, your users might complain though

  7. #7
    Join Date
    Jan 2009
    Posts
    3
    Hi Davey,

    There are no sessions going on in my database, but it is showing many inactive sessions with service name as sys$users and username as that of users created on the database...
    what do you suggest to do with these sessions?
    would it not be wise to kill them?

  8. #8
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    id ask the users what they are doing - rather than just blindly kill things off

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