Re: FB Enqueue
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: <Ravi_Kulkarni@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Jan 2006 23:40:27 -0600
FB enqueue is used when formatting datablocks in an ASSM segment (thus corresponding L1 BMB has to be updated as well). Did you see who was holding this enqueue that others were waiting for? Maybe this process who was formatting new blocks got stuck or in loop somehow while holding the enqueue.
The GTTs shouldn't affect this issue (at least not directly), as GTTs aren't managed using ASSM, they're just some chunks of data in temp tablespace, managed by in-memory structures.
Please let us know how it worked out...
----- Original Message ----- From: <Ravi_Kulkarni@xxxxxxxx>
Sent: Friday, January 13, 2006 9:41 PM
Subject: FB Enqueue
Anyone encountered issue with FB Enqueue (Format Block?). We had 300 sessions waiting on it ; had to bounce the instance to clear all the locks. Using Partitioning/Bulk Inserts/GTT/ASSM. We partitioned a table a week ago.
Have an open Bug with Oracle but just wanted to check if anyone here had a similar one.
Thanks, Ravi. -- http://www.freelists.org/webpage/oracle-l
- FB Enqueue
- From: Ravi_Kulkarni
- FB Enqueue
Other related posts:
- » FB Enqueue
- » Re: FB Enqueue