Thanx Mladen. I checked my listener.ora , tnsnames.ora and init.ora .
there seems to be no special entries for MTS and hence came to a
conclusion that the server runs in dedicated mode.
i read ( somewhere , i don't remember now ) that :
end users ( say , 50 sessions ) doesn't feel any improved p
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
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 addres
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-
Thanx a lot Tanel.
let me read some more docs.
Regards,
Jp.
02-12-2003 18:59:25, "Tanel Poder" <[EMAIL PROTECTED]> wrote:
>Don't worry about dispacther's address, they ought to be running on
>different ports than listener anyway.
>Don't use lsnrctl status for ch
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
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 yo
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'
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.
...a
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,
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 ver
11 matches
Mail list logo