oracle top 5 timed events,CPU Time in Top 5 Timed Events

本文探讨了一项针对运行在Solaris 10上的2节点RAC数据库(10.2.0.3)的性能问题。具体关注的是CMRO应用R12环境下出现的性能下降情况。文中通过分析数据库的等待事件,如CPU时间、dbfile顺序读取等,来诊断可能存在的性能瓶颈。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

Hi,

We have a 2 node RAC database(10.2.0.3) on Solaris 10.

There is performance issue with CMRO application R12.

In database I see CPU time consistently as the top wait event in the Top 5 Timed Events.

This is mostl followed by db file sequential read.

For one of the days:

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 8,383 82.8

db file sequential read 173,417 838 5 8.3 User I/O

SQL*Net break/reset to client 26,015 651 25 6.4 Application

enq: TX - row lock contention 1,063 356 335 3.5 Application

gcs log flush sync 37,747 88 2 .9 Other

For other day:

Top 5 Timed Events

Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class

CPU time 25,286 62.0

db file sequential read 2,644,332 8,267 3 20.3 User I/O

gc buffer busy 1,358,725 3,830 3 9.4 Cluster

read by other session 438,494 1,169 3 2.9 User I/O

SQL*Net more data to client 19,423 879 45 2.2 Network

Any idea of the of the bottleneck?

Thanks

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

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

余额充值