| Growth of Rollback Segments & Attaining size of Database [message #50657] |
Fri, 29 March 2002 04:25  |
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  |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
