I'm going by memory (slightly faulty right now...), but I recall that if you
are using LMT for RBS, you MUST create a 2nd RBS in system before creating
the LMT tablespace and rbs. There is another case where it is required. A
very nice gentleman from Denmark (I'm terrible with names) pointed these out
after my presentation. The LMT one I remembered with prompting, the other I
had never heard of, but made sense... Anyone help a future-alzheimer's
patient here with this one?
I recall the requirement for a second rbs was dropped in 7.3
One of the 9ir2 'bugs' (linux at least) was that all tablespaces had to be
LMT. So in order to create rbs, you had to create a second rbs in system.
However, it would not let you do that. I never followed up for confirmation,
so take with grain o' salt.
Dan
-----Original Message-----
Sent: Wednesday, August 28, 2002 2:50 PM
To: Multiple recipients of list ORACLE-L
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).
--
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).
Received on Wed Aug 28 2002 - 16:18:26 CDT
