Re: Rollback segments

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 29 Jun 1999 20:03:56 GMT
Message-ID: <37790fb1.2026225@news.siol.net>

On Tue, 29 Jun 1999 16:52:08 GMT, cristgar_at_my-deja.com wrote:

>But, How can I know if the R01..R04 segments have
>OPTIMAL size set?. The dba_rollback_segs view doesn't say anything about
>it. I don't like setting the OPTIMAL size of this segments whithout
>knowing it.

It's in V$ROLLSTAT. The column is called OPTSIZE. Try this:

SELECT d.segment_name, v.optsize
FROM dba_rollback_segs d, v$rollstat v
WHERE d.segment_id = v.usn;

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle DBA (7.3 & 8.0 OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Jun 29 1999 - 15:03:56 CDT