CONNECT THROUGH THE LISTENER, AND CONFIRM THAT THE CONNECTION IS THROUGH THE SHARED SERVER MECHANISM

4. Connect through the listener, and confirm that the connection is through the

shared server mechanism:

connect system/oracle@new;select d.name,s.name from v$dispatcher d,v$shared_server s, v$circuit cwhere d.paddr=c.dispatcher and s.paddr=c.server;

This query will show the dispatcher to which your season is connected, and

the shared server process that is executing your query.