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!

gc quiesce wait event on creating an index

RenédHJun 13 2008 — edited Jun 13 2008

Hi,

We're running Oracle 10.2.0.3 in a 2-node RAC.

Today we encountered something strange:
On creating an index on an empty table the session ended up in the 'waiting' state. The event was: 'gc quiesce wait'.

In an attempt to solve it we stopped 1 instance. This didn't help a bit.
Killing the session and restarting the index creation had the same result.
Eventually we bounced the database and then things went fine.

Can anyone explain what might have caused this? I've tried to find an explanation on the internet but can’t really find anything on this wait event.

I’m a newbie on RAC and would like to learn from this…

Regards,

René

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2008

Added on Jun 13 2008

#general-database-discussions

2 comments

678 views