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
> --------------------------------------------------------------------
> 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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Fink, Dan
> INET: Dan.Fink_at_mdx.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).
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ron Thomas
INET: rthomas_at_hypercom.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:05:13 CDT
