Results 1 to 2 of 2

Thread: Estimating UNDO

  1. #1
    Join Date
    Jan 2004
    Posts
    84

    Unanswered: Estimating UNDO

    Hi,
    I need to find out what is the maximum size the UNDO tablespace had undo segments so that I can have the UNDO tablespace sized properly.
    Checking HWM for rollback segments would be OK?
    Need suggestions!

  2. #2
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482

    Re: Estimating UNDO

    Originally posted by preetikate
    Hi,
    I need to find out what is the maximum size the UNDO tablespace had undo segments so that I can have the UNDO tablespace sized properly.
    Checking HWM for rollback segments would be OK?
    Need suggestions!
    Sizing of UNDO depends on UNDO_RETENTION value.
    See http://download-west.oracle.com/docs.../undo.htm#9090

Posting Permissions

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