Databases Reference
In-Depth Information
The listener has been configured to accept the services, which can be verified by
means of the lsnrctl services command:
Each session can be connected by means of a different service name. In the next
example we are connecting three different sessions, each one to a different service:
SQL> select sid, serial#, username, service_name
2 from v$session
3* where username in ('HR','SH','OE')
SID SERIAL# USERNAME SERVICE_NAME
---------- ---------- ------ ---------------- --
132 3713 OE orders
134 2210 HR humanresources
138 8125 SH sales
Search WWH ::
Custom Search