they got rid of it, I think they brought it back for a while, then got
rid of it again... always confused the heck out of me.. which is why I
script and reuse create database stuff.
You people think I KNOW this stuff? Ha! I just have a REALLY good
collection of scripts <G>
- Ron Thomas <rthomas_at_hypercom.com> wrote:
>
> FYI-
>
> FWIR, it is no longer required to create a second rollback segment in
> SYSTEM at database creation.
> This requirement was removed at version 8 (or possibly even 7.3.4).
>
> Ron Thomas
> Hypercom, Inc
> rthomas_at_hypercom.com
> If A = B and B = C, then A = C, except where void or prohibited by
> law. -- Roy Santoro
>
>
>
>
> root_at_fatcity.com
>
> To:
> ORACLE-L_at_fatcity.com
>
> 08/28/02 11:53 AM cc:
>
> Please respond to Subject: RE: How to
> increase maxextents of ROLLBACK segment_type?
> ORACLE-L
>
>
>
>
>
>
>
>
>
> hm, it might be that I was thinking of the "second" rollback segment
> you had to create in the system tablespace before you could create
> any
> other tablespaces....
>
> remove that "might", that sounds more along the lines of what I was
> thinking.
>
> sorry for the confusion. I bow to the "redo/undo/rollback" expert
>
>
> --- "Fink, Dan" <Dan.Fink_at_mdx.com> wrote:
> > Before taking the system rbs offline, contact tech support. I
> recall
> > (perhaps incorrectly...I don't remember whether or not I have
> tested
> > this)
> > that the system rbs is used by the kernel for normal operations and
> > by other
> > transactions if the other rbs are too full. The system rbs should
> > never be
> > specifically allocated to a transaction by a user.
> >
> > Always create additional rollback segments in a separate
> tablespace.
> > If you
> > fill up the rbs tablespace, the transaction fails. If you fill up
> the
> > system
> > tablespace, the database fails.
> >
> > -----Original Message-----
> > Sent: Wednesday, August 28, 2002 7:23 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > create a rollback tablespace, create new rollback segments IN the
> > rollback tablespace and take the rollback segment named "SYSTEM"
> > offline. Do NOT use it.
> >
> > Having an active rollback segment in your system tablespace is like
> > allowing users to create objects there. Especially listen to
> Stephane
> > and READ the manuals. You should not be increasing the allowable
> size
> > of that segment, it should be tiny and unused.
> >
> >
> > --- Jonny Delmont <jonny99delmont_at_yahoo.co.uk> wrote:
> > >
> > > Mark,
> > > Thanks, your command doesn't help. To answer your question,
> > Database
> > > was setup'd by previous DBA. Still i've never seen this type of
> > > segment...
> > > SQL> alter rollback SEGMENT sys.system storage (maxextents 1024);
> > > alter rollback SEGMENT sys.system storage (maxextents 1024)
> > > *
> > > ERROR at line 1:
> > > ORA-02244: invalid ALTER ROLLBACK SEGMENT option
> > >
> > > Jonny
> > > Mark Leith <mark_at_cool-tools.co.uk> wrote: Do you mind if I ask
> > why?
> > > Do you have any other rollback segments in place
> > > other than the SYSTEM one?
> > >
> > > In answer to your question though, look at the error message..
> You
> > > missed
> > > out the word "segment".
> > >
> > > alter rollback SEGMENT sys.system storage (maxextents 1024);
> > >
> > > HTH
> > >
> > > Mark
> > >
> > > ===================================================
> > > Mark Leith | T: +44 (0)1905 330 281
> > > Sales & Marketing | F: +44 (0)870 127 5283
> > > Cool Tools UK Ltd | E: mark_at_cool-tools.co.uk
> > > ===================================================
> > > http://www.cool-tools.co.uk
> > > Maximising throughput & performance
> > >
> > > -----Original Message-----
> > > Sent: 28 August 2002 10:53
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Dear Gurus,
> > > Could you please help me out with this - I want to increase the
> > > maxextents
> > > of below segment.
> > > TIA,
> > > SQL> select OWNER,SEGMENT_NAME,SEGMENT_TYPE,EXTENTS,MAX_EXTENTS
> > > 2 from dba_segments
> > > 3 where ((max_extents-extents)/max_extents)*100 <40 and
> max_extents
> > > != 0
> > > 4 /
> > > OWNER SEGMENT_NAME SEGMENT_TYPE EXTENTS MAX_EXTENTS
> > > ------ --------------- ------------------ ---------- -----------
> > > SYS SYSTEM ROLLBACK 505 505
> > > SQL> connect sys
> > > Enter password:
> > > Connected.
> > > SQL> alter ROLLBACK sys.system storage (maxextents 1024);
> > > alter ROLLBACK sys.system storage (maxextents 1024)
> > > *
> > > ERROR at line 1:
> > > ORA-01902: SEGMENT keyword expected
> > >
> > > TIA
> > > Jonny
> > >
> > >
> > >
> > >
> > >
> > > Get a bigger mailbox -- choose a size that fits your needs.
> > >
> > > http://uk.docs.yahoo.com/mail_storage.html
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Mark Leith
> > > INET: mark_at_cool-tools.co.uk
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > >
> >
> --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
> in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You
> may
> > > also send the HELP command for other information (like
> > subscribing).
> > >
> > >
> > >
> > > ---------------------------------
> > > Get a bigger mailbox -- choose a size that fits your needs.
> > >
> > > http://uk.docs.yahoo.com/mail_storage.html
> >
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Yahoo! Finance - Get real-time stock quotes
> > http://finance.yahoo.com
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Rachel Carmichael
> > INET: wisernet100_at_yahoo.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing
> > Lists
>
=== message truncated ===
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Aug 28 2002 - 15:49:58 CDT
