Yes, it does. 
(Sorry, Dan :). 

>From OEM I see it set to 32765. 

OEM (9i R2) is still a bit dumb when it comes to undo segments,  as it allowed me to 
*attempt* to 
change "Rollback Segment" _SYSSMU1$ to alter its maxextents. 

I received an error, of course, and alert log contained following:

Fri Jul  4 11:15:48 2003
/* OracleOEM */ ALTER ROLLBACK SEGMENT "_SYSSMU1$" STORAGE ( MAXEXTENTS UNLIMITED)
Fri Jul  4 11:15:48 2003
ORA-30019 signalled during: /* OracleOEM */ ALTER ROLLBACK SEGMENT "_SYSSMU1$"...

In OEM, I got to the Edit window for Rollback Segments via Tablespace -> Dependencies 
route ;)   

- Kirti 


--- [EMAIL PROTECTED] wrote:
> Don't know.  I bet Dan Fink does.
> 
> He's in  the air right now on his way to Portland, so I guess he won't be 
> answering this.
> 
> I can ask him at lunch.  :)
> 
> Jared
> 
> 
> 
> 
> 
> 
> "Ryan" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
>  07/02/2003 03:50 PM
>  Please respond to ORACLE-L
> 
>  
>         To:     Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>         cc: 
>         Subject:        Re: RE: Should percent increase higher than 0 in 817?
> 
> 
> does the 32k limit hold in 9i with undo tablespaces?

> ----- Original Message -----
> To: <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, July 02, 2003 5:31 PM
> 
> 
> > Due to bugs and limitations in the internal structure of rollback
> > segments.
> >
> > ie. they aren't allowed more than 32k extents.
> >
> > See MetaLink note  50380.1
> >
> > Jared
> >
> >
> >
> >
> >
> > <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> >  07/02/2003 01:55 PM
> >  Please respond to ORACLE-L
> >
> >
> >         To:     Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> >         cc:
> >         Subject:        Re: RE: Should percent increase higher than 0 in
> 817?
> >
> >
> > i read this somewhere. why is it a bad idea to use maxextents unlimited 
> in
> > your rollback tablespaces?
> > >
> > > From: "Goulet, Dick" <[EMAIL PROTECTED]>
> > > Date: 2003/07/02 Wed PM 04:40:45 EDT
> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > > Subject: RE: Should percent increase higher than 0 in 817?
> > >
> > > Guang,
> > >
> > >                In temp I really don't watch anything.  In Rollback I
> > watch for segments that are approaching maxextents and just plain 
> running
> > out of space.
> > >
> > > Dick Goulet
> > > Senior Oracle DBA
> > > Oracle Certified 8i DBA
> > >
> > > -----Original Message-----
> > > Sent: Wednesday, July 02, 2003 3:51 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > What are the things that we should be monitoring in ROLLBACK or TEMP
> > > tablespace?  So far I don't have any script to monitor ROLLBACK or 
> TEMP
> > > (havn't had any problem though). I too thought Oracle would take care 
> of
> > > rollback and temp ts space management. Right or wrong?
> > >
> > > Guang
<snip> 

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Kirtikumar Deshpande
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (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).

Reply via email to