use "alter rolback segment storage (maxextents ));"
you should not use system rollback for application work. Read doco on how to create
non-system rollback segments.
Long
-Original Message-
Sent: Wednesday, 28 August 2002 8:43 PM
To: Multiple recipients of list ORACLE-L
Jonny Delmon
>
> 08/28/02 11:53 AMcc:
>
> Please respond toSubject: RE
>
> 08/28/02 11:53 AMcc:
>
> Please respond toSubject: RE: How to
> increase maxexte
: 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/rollba
nts of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: How to increase maxextents of ROLLBACK segment_type?
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,EXT
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
sp
Thanks all for your help.
Jonny
Rachel Carmichael <[EMAIL PROTECTED]> wrote:
create a rollback tablespace, create new rollback segments IN therollback tablespace and take the rollback segment named "SYSTEM"offline. Do NOT use it. Having an active rollback segment in your system tablespace is li
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
by: Subject: How to increase maxextents of
ROLLBACK segment_type?
[EMAIL PROTEC
Jonny
The SYSTEM rollback segment is/was created initially on a database build,
and the recommendation has always been to add extra rollback segments
straight away for normal transactional processing. You really *should* have
other rollback segments available for your users.. What output do you g
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)
>> ORA-01902: SEGMENT keyword expected
alter rollback segment sys.system storage (maxextents 1024);
regards,
Mike
-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 maxext
Jonny Delmont wrote:
>
> 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
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
===
: Multiple recipients of list ORACLE-LSubject: How
to increase maxextents of ROLLBACK segment_type?
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
db
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
17 matches
Mail list logo