-
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
-
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.
-
Killing sys$user sessions..
Hi ,
can anyone please tell me if we can kill sys$user or sys$background sessions?
-
you can kill any session - but if you kill a background session your database is going to go down
-
Hi Davey,
would there be any negative impact on database if we kill sys$user sessions only?
-
not on the database, your users might complain though
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|