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