| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: RBS tablespace advise needed
On Wed, 23 Jun 1999 02:31:34 -0400, "Huy Vu" <huyv_at_usa.net>
wrote:
>Today my RBS is full.....I don't know how big the RBS should be....?
>
>Thanks in advance for any idea...
There's no easy answer. It depends on the size of your transactions. If you have batch jobs that update large amounts of data in one transaction, you will need enough rollback space to hold all the undo information. I have a site that uses 100meg rollback segments, with 100 meg extents, because we have some intense batch processing that goes on during the night. My very "unscientific" approach was simply to keep increasing the rollback segment size until we stopped getting errors.
Hope this helps,
Jonathan
 |
 |