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

Thread: deftran always grows

  1. 03-13-2003, 06:05 AM #1
    alainc
    alainc is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 03-13-2003, 11:30 AM #2
    gopi's Avatar
    gopi
    gopi is offline Tree Hugger
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width