Home » RDBMS Server » Server Administration » Growth of Rollback Segments & Attaining size of Database
Growth of Rollback Segments & Attaining size of Database [message #50657] Fri, 29 March 2002 04:25 Go to next message
Prem
Messages: 79
Registered: August 1998
Member
I get a error when executing a PL/SQL ie. it says unable to allocate extents and max extents reached. How am I to increase the size of particular rollback segment, after taking the available harddisk space into consideraton. And also help me in determining the size of the database.
Re: Growth of Rollback Segments & Attaining size of Database [message #50717 is a reply to message #50657] Wed, 03 April 2002 05:41 Go to previous message
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
Senior Member
Make sure the RBS tablespace is big enough.
Make the 'maxextents' for the rollback segment big enough.

You do not increase the size of a rollback segment. It grows and shrinks as work is being done. Just make sure (as metioned above) that you have enough space and enough extents you can grow to. You can shrink the size of a rollback segment if needed (when all work is done)

Good luck.
Previous Topic: Generate Statistics
Next Topic: Oracle sql tuning - reg
Goto Forum:
  


Current Time: Wed Dec 25 00:42:59 CST 2024