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.
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?