IT YES 56575 0
D002(ADDRESS=(PROTOCOL=tcp)(HOST=ora11g)(PORT=21687)) 00000000720C3E18 WAIT YES 56572 0
D003(ADDRESS=(PROTOCOL=tcp)(HOST=ora11g)(PORT=53218)) 00000000720C4ED0 WAIT YES 56569 0
D004 (ADDRESS=(PROTOCOL=tcp)(HOST=ora11g)(PORT=51052)) 00000000720C5F88 WAIT YES 56563 2
?
?
1）在sga 中配置large pool
?
---监控dispatch的使用情况，如果使用率超过50%，需要增加dispatch
SQL> selectname,(busy/(busy+idle))*100 "busyrate" from v$dispatcher;
NAME busy rate
---- ----------
D000 0
D001 0
D002 0
D003 0
D004 .003085705
?
?
关注客户请求在请求队列中等待了多长时间，请求队列中等待的时间越长，则说明客户等待的时间也越长。
?
SQL> select decode(totalq,0,'Norequests') "wait time",
2 wait/totalq||'hundredths ofseconds' "Average wait time per request"
3 from v$queue
4 where type='COMMON';
wait time Average wait time per request
------------------------------------------------------------------------
0hundredths of seconds
0hundredths of seconds
?