Session Management - Oracle 10g/11g Data and Database Management Utilities - page 178

SALES =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = alpha)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = alpha)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = sales)
)
)
DATAWAREHOUSE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = alpha)(PORT = 1522))
(ADDRESS = (PROTOCOL = TCP)(HOST = alpha)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = datawarehouse)
)
)
In this example the same SCOTT database user can use three different connect
descriptors to establish a connection to the database; each service will be later
configured and mapped against a determined plan so that each connection has
specific resource allocation.
Session 1: $ sqlplus SCOTT/TIGER@ALPHA
Session 2: $ sqlplus SCOTT/TIGER@SALES
Session 3: $ sqlplus SCOTT/TIGER@DATAWAREHOUSE
Once the users are connected through the different services this can be monitored on
the V$SESSION dynamic view.