Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: about large and small rollback segments

Re: about large and small rollback segments

From: Yong <yk-park_at_fkl.fujitsu.co.kr>
Date: Thu, 17 Aug 2000 09:59:24 +0900
Message-ID: <8nfdcn$fa6$1@news.nuri.net>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US