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!

eng: BF - allocation contention

78965Jun 30 2010 — edited Jun 30 2010

Anyone seen this before?

I have a new database that I'm doing some testing and tuning on at the moment. While running a load test on it I was viewing the performance page on EM. I saw something I've never seen before. The top wait was "enq: BF - allocation contention". Oracle was saying it was spending significant time on it and it was the highest wait event by far.

I've never seen "enq: BF" before. It shows up in v$event_name as event# 899. But it isn't listed in the Oracle
Enqueue Names documentation. http://bit.ly/afdHeJ

Metalink didn't have anything either.

The database is Linux 11g R1 (11.1.0.4). It's a Dell Server with 2x6 processors, 8GB RAM, and FC storage.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 28 2010

Added on Jun 30 2010

#11g, #database, #general-database-discussions, #performance

7 comments

6,032 views