1。ORACLE7.3升级8.17后性能严重下降
1)服务端升级后将初始化文件的三个参数
shared_pool_size=150M
large_pool_size=5M
log_buffer=15M
性能仍然低下
2)客户端将文件物理删除(无法卸载),清楚注册表后重新 安装8.17客户端,重起后无法连接到服务端。只好用7.3客户端(不知是否因此引起性能低下)
2。服务器双CPU,在高峰期速度并不满,但在低峰期速度其慢,什么原因,大家帮帮我!
3。以下是我测试库的REPORT,如何分析?
select namespace library,
gets,
round(decode(gethits,0,1,gethits)/decode(gets,0,1,gets),3)
gethitratio,
pins,
round(decode(pinhits,0,1,pinhits)/decode(pins,0,1,pins),3)
pinhitratio,
reloads, invalidations
from stats$lib;
LIBRARY
GETS GETHITRATIO PINS PINHITRATIORELOADS
--------------- ---------- ----------- ---------- ----------- ----------
INVALIDATIONS
-------------
BODY
0 1
0 1
0
0
CLUSTER
0 1
0 1
0
0
INDEX
0 1
0 1
0
0
LIBRARY
GETS GETHITRATIO PINS PINHITRATIORELOADS
--------------- ---------- ----------- ---------- ----------- ----------
INVALIDATIONS
-------------
OBJECT
0 1
0 1
0
0
PIPE
0 1
0 1
0
0
SQL AREA
24.792 72.861
0
0
LIBRARY
GETS GETHITRATIO PINS PINHITRATIORELOADS
--------------- ---------- ----------- ---------- ----------- ----------
INVALIDATIONS
-------------
TABLE/PROCEDURE 22 1 26 1
0
0
TRIGGER
0 1
0 1
0
0
8 rows selected.
|