Re: shared server or dedicated server -- How to find ?

Use "lsnrctl services" to see which services have been registered with your listener.
Your dispatcher hasn't probably registered it's services with listener. Try "alter system register".
If you still don't see any "shared" services (handler=dispatcher) under lsnrctl services, then your dispatchers register with wrong listener (or don't register at all).
Check values of local_listener, remote_listener, mts_listener_address and see if they match your listener's address. If the parameters are default then dispatchers try to register them with listener on localhost:1521

If you get your services registered, but all new connections still remain DEDICATED, then check whether you don't have (SERVER=EDICATED) in your tnsnames.ora entries. Note that background processes servers in v$session are always dedicated.

Tanel.

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, December 02, 2003 10:39 AM

> Tanel ,
>
> v$mts, v$dispatcher, v$shared_server all have a record each.
>
> but:
> SQL> select server, count(*) from v$session group by server;
> this query says that all conn are dedicated.
> but the tnsnames.ora in the client (webserver) doesn't enforce for a
dedicated conn.
>
> ...and LSNCRSTL STATUS doesn't show anything reg. dispatcher.
>
> why it is so ? any thoughts ?!!
>
> Thanks & Regards,
> Jp.
>
> 02-12-2003 15:54:24, "Tanel Poder" <tanel.poder.003_at_mail.ee> wrote:
>
> >I would use:
> >select server, count(*) from v$session group by server;
> >
> >That way you'll see how many sessions are using shared servers & how many
> >are forced to be dedicated. (you can have dedicated connections in MTS as
> >well).
> >
> >Otherwise, you can check views v$mts, v$dispatcher, v$shared_server for
> >statistics.
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Prem Khanna J
> INET: jprem_at_kssnet.co.jp
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tanel Poder
  INET: tanel.poder.003_at_mail.ee

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).