Oracle Database Discussions

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!

AWR analyse help

41925Sep 24 2009 — edited Sep 27 2009

Hi,all.

Please help me out!

Last sunday one node of My RAC hang. AWR says a very high "events in waitclass Other":

Event Waits %Time -outs Total Wait Time (s) Avg wait (ms) Waits /txn
events in waitclass Other 59,309,000 99.65 1,438 0 620.91

At that time, some sql hang at get sequence nextval().

Problem like this has occured several times.

We have got advice from dba to increase sequence's cache size.

I have read http://www.pythian.com/news/383/sequences-in-oracle-10g-rac

Maybe we need try to decrease sequence usage ?

How can I prove that's right solution?

How can I attach a AWR file in this post?

Thanks for your time!

Edited by: cuterat on 2009-9-24 下午12:08

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 25 2009

Added on Sep 24 2009

#general-database-discussions, #in

9 comments

4,303 views