Home » RDBMS Server » Server Administration » shared server confusion
shared server confusion [message #197890] Fri, 13 October 2006 02:36
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
I am using oracle 8i server and have the following parameters
SQL> show parameter mts_dispatchers

NAME TYPE VALUE
------------------------------------ ------- --------------------
mts_dispatchers string (PROTOCOL=TCP)(PRE=oracle.auro
ra.server.SGiopServer)
SQL> show parameter mts_servers

NAME TYPE VALUE
------------------------------------ ------- ----------
mts_servers integer 1

SQL>select status,sum(owned) clients,sum(busy)*100/sum(idle) rate
from v$dispatcher
group by status
STATUS CLIENTS RATE
---------------- ---------- ----------
WAIT 0 0



SQL>select name,requests,busy*100/(busy+idle) "rate",status
from v$shared_server
where status<>'QUIT'

NAME REQUESTS rate STATUS
---- ---------- ---------- ----------------
S000 0 0 WAIT(COMMON)


SQL>select decode(totalq,0,'No Request',wait/totalq||'hundreth of a second') "Average Wait Time"
from V$queue
where type='COMMON'

Average Wait Time
--------------------------
No Request


What does it means that REQUESTS=0 on Shared server process S000
Clients =0 on a dispatcher process
No Request are pending in queue?
I am really confused with it
Can u please help me in this regard?
thanx in advance

Previous Topic: some clarifications in Oracle
Next Topic: the oracle9i jvm version
Goto Forum:
  


Current Time: Tue Dec 06 00:10:44 CST 2016

Total time taken to generate the page: 0.09682 seconds