RE: rollbacksegment optimal size

  • From: "Ignizio, Richard" <richard.ignizio@xxxxxxxxxx>
  • To: "'dba.orcl@xxxxxxxxx'" <dba.orcl@xxxxxxxxx>, Oracle Discussion List <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 30 Sep 2004 08:40:44 -0400

Sami,

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

Rich

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: