1 Reply Latest reply: Jan 30, 2014 7:26 AM by 985871 RSS

    Delete query from mlog taking time

    985871

      Hi Gurus ,

       

      I am using 10.2.0.3 database and the below query is running regularly through a procedure taking almost 400 seconds.

       

      --------------------------------------------------------------------------------------------------
      | Id  | Operation          | Name                        | Rows  | Bytes | Cost (%CPU)| Time     |
      --------------------------------------------------------------------------------------------------
      |   0 | DELETE STATEMENT   |                             |       |       |     2 (100)|          |
      |   1 |  DELETE            | MLOG$_DAILY_POLLING_REGIME1 |       |       |            |          |
      |   2 |   TABLE ACCESS FULL| MLOG$_DAILY_POLLING_REGIME1 |     1 |     9 |     2   (0)| 00:00:01 |
      --------------------------------------------------------------------------------------------------

       

      The Query is :-

      delete FROM "QOSDEV"."MLOG$_DAILY_POLLING_REGIME1"  WHERE snaptime$$ <= :1

      Thanks for your help .

      Regards,

      Dbapps