- 最后登录
- 2016-1-18
- 在线时间
- 80 小时
- 威望
- 44
- 金钱
- 645
- 注册时间
- 2011-12-27
- 阅读权限
- 10
- 帖子
- 89
- 精华
- 0
- 积分
- 44
- UID
- 125
|
1#
发表于 2012-7-5 12:00:33
|
查看: 4489 |
回复: 5
今天看到刘“11g中AWR新快照视图”的贴子。使用其中的语句查询出几个topsql
SN SQL_ID CPU WAIT IO TOTAL
---------- ------------- ---------- ---------- ---------- ----------
1 4ah1s5jkpg2nd 0 6033 112 6145
2 d90zzgkqqb4s4 0 1227 2463 3690
3 8szmwam7fysa3 0 0 3150 3150
4 1bbruszu1d2z4 0 1792 75 1867
5 7ztdck1vvj1yg 0 0 1693 1693
6 db7vhxa3p8v7w 0 0 1599 1599
7 7azp46cfpx90p 0 6 1517 1523
8 272hznyn8bpcx 0 360 820 1180
9 8mfngut080fvf 0 65 1101 1166
10 1nmzgq7mp6d9r 0 0 1111 1111
10 rows selected.
其中第二句sql_text如下
select /*+ parallel_index(t, "IDX_JZDJINFORJZDJMIDSHIT",128) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring no_substrb_pad no_expand index_ffs(t,"IDX_JZDJINFORJZDJMIDSHIT") */ count(*) as nrw,count(distinct sys_op_lbid(76203,'L',t.rowid)) as nlb,count(distinct hextoraw(sys_op_descend("MEMBERID")||sys_op_descend("CYJSSH")||sys_op_descend("INTYPE"))) as ndk,sys_op_countchg(substrb(t.rowid,1,15),1) as clf from "HCHGB"."JZDJINFOR" sample block ( 2.8695793365,1) t where "MEMBERID" is not null or "CYJSSH" is not null or "INTYPE" is not null
想请教 字段 nullable 设置对select,insert,update的影响,及各位的意建与建议。 |
|