sys$users in v$session

[Nugpot]

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

[Thomasps]

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.

[Jackie007]

Hi ,

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

[davey23uk]

you can kill any session - but if you kill a background session your database is going to go down

[Jackie007]

Hi Davey,

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

[davey23uk]

not on the database, your users might complain though

[Jackie007]

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?

[davey23uk]

id ask the users what they are doing - rather than just blindly kill things off