Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Rollback Buffer Help!

Re: Rollback Buffer Help!

From: Laurie Kirsh <lkirsh_at_itsc.org>
Date: 1997/05/22
Message-ID: <01bc6682$7c234880$2d2bb1cc@Kirsh.itsc.state.md.us>#1/1

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>...

> 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
> >
>
Received on Thu May 22 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US