Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Rollback Buffer Help!
look in your init.ora file to figure out the name of your RBS
-- +-------------------------------------+-----------------------------+ | Laurie J. Kirsh | Oracle DBA/Design/Developer | | lkirsh_at_itsc.org | Integration Systems Analyst | | Lockheed Martin | ITSC project | | 301-982-1113 | College Park, Maryland | +-------------------------------------------------------------------+ James Darden <jimpd_at_seanet.com> wrote in article <01bc633d$655ed580$17830ccf_at_ibm.ibm.net>...Received on Thu May 22 1997 - 00:00:00 CDT
> Okay that sounds easy and I'm sure it is...but not for a novice like me.
> How do I increase the storage parameters in the rollback segment? I
tried
> doing it but I failed to figure out what the name of the rollback segment
> was (I think that was the problem). I'm sure I'm not the first person to
> run into this problem. My tablespace is 50MB so I don't think I will
exceed
> that. My Oracle manual gives me the SQL statement and all the options
but
> I'd like to see a real world example of how to do this.
>
> Thanks again in advance for all the help.
>
> Sheilah Scheurich <scheuric_at_sprynet.com> wrote in article
> <337d31e4.4306394_at_news.interserv.com>...
> > Just increase the storage parameters in the rollback segment. Make
> > sure that when fully extended, the segment will not exceed the size of
> > the tablespace.
> >
> > -Sheilah Scheurich
> > DBA
> > scheuric_at_sprynet.com
> >
>