---------------------------- ----------------------------------------------------------------
Other enq: FB - contention
-------------------------------- -------------------------------- -------------------------------- --------------------------------
enq: FB - contention name|mode tablespace # dba
http://www.dba-oracle.com/t_enqueue_wait_types_.htm
"well the format block enqueue ("enq: fb contention") is related to grabbing
new blocks in ASSM tablespaces, during an insert operation for example. It
might be a good idea at this point to find out what the 'query' is that you
are actually doing and if it is happening in parallel etc. Incidentally are
both of these queries on the one system, or is one PROD and one UAT?"
转载:http://blog.chinaunix.net/uid-499812-id-3046288.html