Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    1

    Red face Unanswered: How to delete transactions from deferred queue

    I'm unable to delete transactions from the
    deferred transaction queue. I've executed the procedure
    DBMS_DEFER_SYS,DELETE_TRAN(null,null) but it has been
    working now for 12 hours and does nothing. I can't stop replication so the transactions keep going into the queue.

  2. #2
    Join Date
    Sep 2003
    Location
    Virginia, USA
    Posts
    246
    I've seen it take 24 hours to delete from deferror and deftran on large systems. It must do things the *right* way, whatever that is. I've also seen it finish in under 1 minute. It depends on a few factors. IF the system has users generating new errors or transactions, then it takes very much longer. Unfortunately, there are no intermediate commit points, so if it fails or gets interrupted you have to start over.
    MarkRem
    Author, Oracle Database 10g: From Nuts to Soup
    http://www.remidata.com/book_nuts2soup.htm

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •