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

Thread: EXP, consistent=y equals large rollback segs, why?

Threaded View

  1. #2
    Join Date
    Jan 2001
    Posts
    3,134
    Hey Gus;

    Not sure what you mean by queued. I think any updates on those tables would generate (and be stored in) rollback. Than applied after the table is released. I think that is what Oracle is saying here.

    "If you use CONSISTENT=y and the volume of updates is large, the rollback segment usage will be large. In addition, the export of each table will be slower because the rollback segment must be scanned for uncommitted transactions."

    MH
    Last edited by Mr.Hanky; 01-05-2004 at 01:28 PM.
    I remember when this place was cool.

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