DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001

    Question deftran always grows

    Hi i'm using 9.2 W2K with replication the deftran never purge even when i scheduled the DBMS_DEFER_SYS.PURGE proc or when i start it manually.
    all my replication transaction are done well
    how to purge it thanks


  2. #2
    Join Date
    Dec 2001
    Keene, NH
    Open a tar.... I predict the folks at tech support will guide you pretty quickly.

    Once upon a time in Oracle 8i, I had an issue where the purge happened correctly but the blocks in DEFTRAN never made it back onto the freelist and the segment grew and grew and grew even though there were few rows in DEFTRAN. I can't recall the solution, just the work around that made us periodically stop replication.

    Wish I could be more help
    Last edited by gopi; 03-13-2003 at 10:40 AM.

Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.