1. 采集时间短了点,30分钟到60分钟比较好
2. 从TOP5 wait event你就能看出系统的瓶颈是什么了.
% Total
Event
WaitsTime (s) Ela Time
db file scattered read
14,939 5
4.27
可能的原因:全表扫描比较多,SQL语句没有使用索引
再看这些SQL语句:
第一组:
select gou.group_uuid, sg.sgroup_name, sg.sgroup_uuid, od.organi
ze_uuid, od.organize_name from upc_group_own_users gou, upc_user
uu, upc_group ug, upc_single_group sg, upc_organize_domain od w
here uu.user_login_name='2304119' and gou.user_uuid = uu.user_uu
id and ug.group_uuid = gou.group_uuid and sg.sgroup_uuid = ug.sg
select gou.group_uuid, sg.sgroup_name, sg.sgroup_uuid, od.organi
ze_uuid, od.organize_name from upc_group_own_users gou, upc_user
uu, upc_group ug, upc_single_group sg, upc_organize_domain od w
here uu.user_login_name='2304918' and gou.user_uuid = uu.user_uu
id and ug.group_uuid = gou.group_uuid and sg.sgroup_uuid = ug.sg
第二组:
select gou.group_uuid, sg.sgroup_name, sg.sgroup_uuid, od.organi
ze_uuid, od.organize_name from upc_group_own_users gou, upc_user
uu, upc_group ug, upc_single_group sg, upc_organize_domain od w
here uu.user_login_name='2204004' and gou.user_uuid = uu.user_uu
id and ug.group_uuid = gou.group_uuid and sg.sgroup_uuid = ug.sg
select gou.group_uuid, sg.sgroup_name, sg.sgroup_uuid, od.organi
ze_uuid, od.organize_name from upc_group_own_users gou, upc_user
uu, upc_group ug, upc_single_group sg, upc_organize_domain od w
here uu.user_login_name='2104029' and gou.user_uuid = uu.user_uu
id and ug.group_uuid = gou.group_uuid and sg.sgroup_uuid = ug.sg
...
很明显,语句没有使用绑定变量 ...
先看看上面这个语句的查询计划再说 ?
另外,有些初始化参数也设置的不是很合理:
JAVA_POOL_SIZE, LARGE_POOL_SIZE 都太大
最初由 phigon 发布
[B]如题 [/B]
|