Chinese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

11gR2 v$lock查询慢并cpu高占用

saup007Nov 22 2012 — edited May 25 2013

在10gR2中并没有此问题，select * from v$lock 很快。
在11.2.0.2中查询，明显看到一颗cpu占用100%，或70%以上，时间1分钟以上才能查询

我们有一监控，要经常查询，11gR2遇到这个问题了，肿么办？大伙有什么建议吗？

SELECT COUNT (*)
  FROM v$lock
 WHERE block = 1 OR request <> 0;

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2013

Added on Nov 22 2012

#11gr2, #ask-maclean, #产品, #数据库

2 comments

3,161 views