-
RBS Question
Hello:
Every week when we run batch jobs, and a rbs is used and after data is committed, it still takes certain time to shrink.. Meanwhile if any other transaction is growing it does not have enough extents and fails due to that? I have already increased RBS tablespace to about 5GB and cannot increase more and more..
What is the best way to deal with this situation. I don't know how it will react if I shrink it manually. Are there any parameters to deal with this?
Thanks, ST2000
-
Set optimal size for rollback segments
like
alter ROLLBACK SEGMENT rb_large storage (optimal 50m);
I think that even some rollback segments are bigger(after commit), the space is still reuseable (not 100% sure).
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|