Alex ,
Not necessarily . All you have to do is build a
rollback segment in the rollback TBS and bring it
online .
Cheers,
RS
--- "Hillman, Alex" <Alex.Hillman_at_usmint.treas.gov>
wrote:
> Also you need rollback segment in system when
> creating database if your
> rollback tablespace is LMT.
>
> Alex Hillman
>
> -----Original Message-----
> [mailto:danisment.unal_at_unal-bilisim.com]
> Sent: Wednesday, July 11, 2001 4:44 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hello,
>
> SYSTEM rbs is reserved actions against the SYSTEM
> tablespace.
>
> There are some mis-conceptions against this issue.
>
> Actions against the SYSTEM tablespace can use
> non-SYSTEM rbs, too.
>
> For example, Recursive transactions,in other words:
> Oracle kernel
> transactions
> by SYS users, do not always have to use SYSTEM rbs.
>
> SYSTEM rbs is the last statation if there is no
> available slot in rbs in
> which
> current user transaction is assigned. So, Oracle
> kernel does not have to
> compete with user transactions.
>
> hope this helps...
>
> Kevin Lange wrote:
>
> > As a guess I would think it was because the system
> tablespace is so active
> > with all the queries against the catalog.
> >
> > -----Original Message-----
> > Sent: Wednesday, July 11, 2001 12:03 PM
> > To: Multiple recipients of list ORACLE-L
> >
> > Hi Everybody
> >
> > I'm running 8.1.7 and i just read that i should
> have a second rollback
> > segment in the system tablespace.
> > Can someone tell me why this is and how big should
> i create it?
> > --
> > Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> > --
> > Author: hp
> > INET: hp_at_lechateau.ca
> >
> > 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: Kevin Lange
> > INET: kgel_at_ppoone.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: Danisment Gazi Unal (Unal Bilisim)
> INET: danisment.unal_at_unal-bilisim.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: Hillman, Alex
> INET: Alex.Hillman_at_usmint.treas.gov
>
> 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!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sakthi , Raj
INET: rajan_sakthi_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 Thu Jul 12 2001 - 09:52:08 CDT
