| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
