Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: about large and small rollback segments
yes, absolutely, there is a tread-off between large segment and small segment.
in the performance view,
a few large segments are better for DSS many small segments are better for OLTP
:))
Phil <phil_sheu_at_amax.com>ÀÌ(°¡) ¾Æ·¡ ¸Þ½ÃÁö¸¦
news:DGBm5.667$2l4.19059_at_newsread2.prod.itd.earthlink.net¿¡ °Ô½ÃÇÏ¿´½À´Ï´Ù.
> Hi,
>
> if disk storage is not a problem, can we make every rollback segment
larger?
>
> is there a trad-off for large rollback segment?
>
> Thanks and have a nice day!
>
> Phil
>
>
Received on Wed Aug 16 2000 - 19:59:24 CDT