Re: RE: Should percent increase higher than 0 in 817?

From: Kirtikumar Deshpande <kirtikumar_deshpande_at_yahoo.com>
Date: Fri, 04 Jul 2003 09:59:23 -0700
Message-ID: <F001.005C364B.20030704093932@fatcity.com>

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).

Received on Fri Jul 04 2003 - 11:59:23 CDT