RE: rollbacksegment optimal size

From: Ignizio, Richard <richard.ignizio_at_PaeTec.com>
Date: Thu, 30 Sep 2004 08:40:44 -0400
Message-ID: <119D5A215F15D4119BE9009027FC20D70C246DAC@exch2-corp.paetec.com>

Sami,

Look at the v$rollstat view to get the optimal size for the rollback segments.

Rich

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Sami Seerangan Sent: Thursday, September 30, 2004 8:31 AM To: Oracle Discussion List
Subject: rollbacksegment optimal size

Hi All,

What is the view I should look at to find an optimal size in data dictinary?

Thanks in advance,
--

Sami Seerangan
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 30 2004 - 07:33:52 CDT