Stefan, is the session waiting on a single block or are the blocks changing? If it is a single block, can you look into V$BH and see the status? If the blocks are changing, there may be something wrong with your execution plan. On 03/31/2004 12:33:41 PM, Stefan Jahnke wrote: > Hi list > -- Mladen Gogala Oracle DBA ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------