Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

UNDO_TABLESPACE

846231Jan 4 2013 — edited Jan 6 2013

Hi all,

Is it ok if I change my UNDO_TABLESPACE intial_exten, next_extent to 1M by 1M? (maybe equivalent to RBS_BIG) the default is 100k by 65k
This is intended for long runnings jobs which creates lots of extents when reading large amount of data.

Thanks a lot,

Kins

This post has been answered by Fran on Jan 4 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 3 2013

Added on Jan 4 2013

#general-database-discussions

15 comments

567 views