problem with gather_schema_stats after updating a BLOB column

From: slim <sfar_selim_at_excite.com>
Date: 6 Jun 2002 02:02:51 -0700
Message-ID: <491f65ba.0206060102.23f204b9@posting.google.com>

Hi,

• this is a sample code, where the exception occurs when calculating
• statistics
• ORA-04020: deadlock detected while trying to lock object USER1.tab_pictures
• thanks for help

 DECLARE
   blob_gra BLOB;
 BEGIN
   SELECT pic_graphic

       INTO blob_gra
       FROM tab_pictures
      WHERE pic_id = 100 AND
            pic_type = 'GIF'
      FOR UPDATE;

   DBMS_LOB.OPEN( blob_gra, DBMS_LOB.LOB_READWRITE );    DBMS_LOB.CLOSE( blob_gra);

   dbms_stats.gather_schema_stats(ownname => 'USER1',

                                  cascade => TRUE);

  EXCEPTION
    WHEN OTHERS THEN
      RAISE;
  END; Received on Thu Jun 06 2002 - 04:02:51 CDT