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
Hi,
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...
Tanel.
----- Original Message -----
From: <Ravi_Kulkarni@xxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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.
9205/RAC/RH-Linux
Thanks,
Ravi.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts: