- 最后登录
- 2018-11-1
- 在线时间
- 377 小时
- 威望
- 29
- 金钱
- 6866
- 注册时间
- 2011-10-12
- 阅读权限
- 200
- 帖子
- 891
- 精华
- 4
- 积分
- 29
- UID
- 1
|
10#
发表于 2013-9-21 19:44:14
Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class
latch free 3,447,742 976,595 283 114.3 Other
latch: library cache 1,793,091 525,062 293 61.5 Concurrency
latch: shared pool 641,676 185,892 290 21.8 Concurrency
latch: session allocation 514,471 150,578 293 17.6 Other
db file scattered read 582,742 13,670 23 1.6 User I/O
Statistic Name Time (s) % of DB Time
connection management call elapsed time 619,966.03 72.58
sql execute elapsed time 136,423.88 15.97
parse time elapsed 77,184.91 9.04
Elapsed Time (s) CPU Time (s) Executions Elap per Exec (s) % Total DB Time SQL Id SQL Module SQL Text
9,698 234 1 9697.73 1.14 f7j4rubxmnwtp create table ry_a_20680_xxt_cr...
当时有执行
create table ry_a_20680_xxt_crm as select /*+parallel(a, 3) parallel(b, 3) use_hash(a, b)*/ a.subsid, wm_concat(b.prodname) prodname, sum(b.prodvalue) payment from ry_a_20680_xxt_user a, ry_a_20680_xxt_prod b where a.prodid = b.prodid group by a.subsid
|
|