oracle 业务事件,ORACLE等待事件：direct path write

最新推荐文章于 2022-02-24 17:28:19 发布

简森刘

最新推荐文章于 2022-02-24 17:28:19 发布

阅读量188

点赞数

文章标签： oracle 业务事件

select sample_time,event,count(*) from dba_hist_active_sess_history where dbid=3965601902 and

snap_id>49716 and snap_id<49720 and sample_time

and sample_time>to_date('20150527 10:20:00','yyyymmdd hh24:mi:ss') group by sample_time,event

order by sample_time;

SAMPLE_TIME EVENT COUNT(*)

---------------------------------------- ---------------------------------------- ----------

27-MAY-15 10.20.03.814 AM 1

27-MAY-15 10.20.06.144 AM db file sequential read 1

27-MAY-15 10.20.13.914 AM 1

27-MAY-15 10.20.16.244 AM 1

27-MAY-15 10.20.24.014 AM db file sequential read 1

27-MAY-15 10.20.24.014 AM 2

27-MAY-15 10.20.26.343 AM 2

27-MAY-15 10.20.34.114 AM db file sequential read 1

27-MAY-15 10.20.36.443 AM 3

27-MAY-15 10.20.44.224 AM 1

27-MAY-15 10.20.46.553 AM 1

27-MAY-15 10.20.54.324 AM db file sequential read 1

27-MAY-15 10.20.54.324 AM direct path write 8

27-MAY-15 10.21.04.424 AM db file sequential read 1

27-MAY-15 10.21.04.424 AM direct path write 10

27-MAY-15 10.21.04.424 AM enq: TX - row lock contention 1

27-MAY-15 10.21.04.424 AM 1

27-MAY-15 10.21.06.753 AM db file sequential read 1

27-MAY-15 10.21.06.753 AM 6

27-MAY-15 10.21.14.525 AM db file sequential read 1

27-MAY-15 10.21.14.525 AM direct path write 17

27-MAY-15 10.21.14.525 AM enq: TX - row lock contention 2

27-MAY-15 10.21.14.525 AM 1

27-MAY-15 10.21.16.853 AM gc current block 2-way 1

27-MAY-15 10.21.16.853 AM gc current grant 2-way 1

27-MAY-15 10.21.16.853 AM kjbdrmcvtq lmon drm quiesce: ping completion 1

27-MAY-15 10.21.16.853 AM log file sync 8

27-MAY-15 10.21.16.853 AM wait for scn ack 1

27-MAY-15 10.21.16.853 AM 5

27-MAY-15 10.21.24.624 AM db file sequential read 1

27-MAY-15 10.21.24.624 AM direct path write 26

27-MAY-15 10.21.24.624 AM enq: TX - row lock contention 3

27-MAY-15 10.21.24.624 AM gcs drm freeze in enter server mode 1

27-MAY-15 10.21.24.624 AM 1

27-MAY-15 10.21.26.953 AM 1

27-MAY-15 10.21.34.814 AM db file sequential read 1

27-MAY-15 10.21.34.814 AM direct path write 33

27-MAY-15 10.21.34.814 AM enq: TX - row lock contention 4

27-MAY-15 10.21.34.814 AM gcs drm freeze in enter server mode 1

27-MAY-15 10.21.34.814 AM row cache lock 10

27-MAY-15 10.21.34.814 AM 1

27-MAY-15 10.21.37.053 AM db file sequential read 1

27-MAY-15 10.21.37.053 AM 1

27-MAY-15 10.21.44.914 AM db file sequential read 1

27-MAY-15 10.21.44.914 AM direct path write 42

27-MAY-15 10.21.44.914 AM enq: TX - row lock contention 4

27-MAY-15 10.21.44.914 AM enq: US - contention 1

27-MAY-15 10.21.44.914 AM gcs drm freeze in enter server mode 1

27-MAY-15 10.21.47.163 AM log file parallel write 1

27-MAY-15 10.21.47.163 AM 1

27-MAY-15 10.21.55.014 AM db file sequential read 1

27-MAY-15 10.21.55.014 AM direct path write 42

27-MAY-15 10.21.55.014 AM enq: TX - row lock contention 5

27-MAY-15 10.21.55.014 AM gc current block 2-way 1

27-MAY-15 10.21.55.014 AM gc current grant 2-way 2

27-MAY-15 10.21.55.014 AM kjbdrmcvtq lmon drm quiesce: ping completion 1

27-MAY-15 10.21.55.014 AM log file sync 3

27-MAY-15 10.21.55.014 AM wait for scn ack 1

27-MAY-15 10.21.55.014 AM 5

27-MAY-15 10.21.57.263 AM db file parallel write 1

27-MAY-15 10.21.57.263 AM 1

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
oracle 业务事件,ORACLE等待事件：direct path write

select sample_time,event,count(*) from dba_hist_active_sess_history where dbid=3965601902 andsnap_id>49716 and snap_id<49720 and sample_timeand sample_time>to_date('20150527 10:20:00','yyyym...
复制链接

扫一扫

评论

被折叠的条评论为什么被折叠?

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。