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