deftran always grows
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: deftran always grows

  1. #1
    Join Date
    Jan 2001
    Posts
    44

    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

    Alain

  2. #2
    Join Date
    Dec 2001
    Location
    Keene, NH
    Posts
    510
    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 11: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