Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote in message news:<oj069vo9jglvo9rrg6q8fhb8rpl6oaeik4_at_4ax.com>...
> On 08 Apr 2003 18:15:12 +1000, Tim X <timx_at_spamto.devnul.com> wrote:
>
> >2. According to the Oracle 8i documentation, if you do not include
> > your rollback segments in the rollback_segment parameter in the
> > init.ora file, your rollback segments will not be brought back
> > on-line when you bring your database up and will need to explicitly
> > be brought on-line with a alter statement. THis is in addition to
> > the rollback_segments other role relating to public/private rbs and
> > parallel servers. I have done some experiments with 8i and this
> > does not seem to be the case. If I don't include the RBS in the
> > parameter file, they still come up on-line when the db is
> > started. Again, is this just old documentation left from an earlier
> > Oracle version, a documentation error or am I missing something?
>
> PUBLIC rollback segments come up automatically. PRIVATE rollback
> segments must be in init.ora or brought up manually. You probably have
> PUBLIC rollback segments, which you can verify by looking at the owner
> of the rollback segment
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Just an addition. There is also SYSTEM rollback segment which comes online
first. It's always there, and Oracle tries to use it for special operations
only.
Received on Wed Apr 09 2003 - 10:44:36 CDT
