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,
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.
Tanel List,
SQL select name,network,status, from v$dispatcher;
NAME: D000
NETWORK : (ADDRESS=(PROTOCOL=tcp)(HOST=oradb)(PORT=1027))
STATUS : WAIT
my listener.ora doesn't have an entry for this and LSNRCTL STATUS
doesn't show that it's
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
Don't worry about dispacther's address, they ought to be running on
different ports than listener anyway.
Don't use lsnrctl status for checkin services, lsnrctl services is for that.
Yes, in Oracle you can directly connect to your dispatcher as well if you
want to (some people have
This may help ...
select server from v$session where audsid = USERENV ('SESSIONID') ;
Thanks,
Nick Khimani
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Nikhil Khimani
INET: [EMAIL PROTECTED]
Fat City Network Services
Let me note that I used listener status to figure out services
because the output of stat is more compact and easier to read.
Of course, one should always use services to look see how services
are configured.
On 12/02/2003 04:59:25 AM, Tanel Poder wrote:
Don't worry about dispacther's address,
Prem, MTS configuration requires cooperation of two peaces
of software: RDBMS and listener. It's not enough to check
the database configuration, you should also check listener.ora
and tnsnames.ora
On 12/02/2003 03:39:26 AM, Prem Khanna J wrote:
Tanel ,
v$mts, v$dispatcher, v$shared_server
List ,
I would like to know whether my database is running on
shared server (MTS) or dedicated server mode ?
How do i find it out ?
it's oracle 9.2.0.3 on Win2k.
Regards,
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL
Your database is not running on either share or dedicated session mode. Your
sessions are connecting to either a dedicated server or a shared server. You can
have a mix as well. Some sessions may be connecting to dedicated servers while
others may be utilizing shared servers. It doesn't sound
10 matches
Mail list logo
