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).
Received on Wed Aug 28 2002 - 11:51:56 CDT
