This is the documented behavior, and I would expect this behavior with any version. (Docs have always defined "SYS$USERS" as the service for connections that don't use a service, i.e. they use SID.) For example, here: http://download.oracle.com/docs/cd/E11882_01/rac.112/e16795/hafeats.htm#RACAD7123 -Jeremy On 7/7/2011 9:22 AM, Niall Litchfield wrote: > Someone, somewhere asked me if users connecting to a database using > SID in the tnsnames file actually got connected to the SYS$USERS > service. I have lost my note of where I was asked this, but oracle-l > seems likely. The answer is (at least in 11.2 on Windows) yes. I > apologize if this is meaningless to everyone. In the output below SID > is my sql prom tnsalias with SID specified in connect descriptor - > niall is the service_name variant. I've only edited the output for > domain name. > > SQL >conn niall/niall@sid > > NIALL @ sid >select service_name from v$session where sid = (select > sid from v$mystat where rownum = 1); > > SERVICE_NAME > ---------------------------------------------------------------- > SYS$USERS > > NIALL @ sid >conn niall/niall@niall > Connected. > NIALL @ niall >select service_name from v$session where sid = (select > sid from v$mystat where rownum = 1); > > SERVICE_NAME > ---------------------------------------------------------------- > niall.domain.name <http://niall.domain.name> > -- http://www.ardentperf.com +1 312-725-9249 Jeremy Schneider Chicago