Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: system rollback segments

Re: system rollback segments

From: Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net>
Date: Tue, 08 Feb 2005 16:26:12 GMT
Message-ID: <jvph01h71c6bgejnsppuo81gkiff4ufipa@4ax.com>


On Wed, 02 Feb 2005 23:02:51 +0100, Frank van Bortel <fvanbortel_at_netscape.net> wrote:

>Dave wrote:
>> "Vince Laurent" <vincelaurent_at_REMOVETHISsbcglobal.net> wrote in message
>> news:7p82011a3jhh1ev2v456utq7ncq9kn4o3u_at_4ax.com...
>>
>>>I moved our system to undo from rollback but I keep seeing messages
>>>from our monitoring software like the following. Why are there
>>>rollback segements in the system tablespace? Why did I get a warning
>>>the other day that there was 1 offline, then the day after 2, now
>>>there is 3? Where are they coming from? We are running Oracle 9.2.0.4
>>>on HPUX 11i
>>
>> system rollback segment is always in the system tablespace
>>
>> oracle constantly onlines and offlines rollback segments so its not a
>> problem, you need to update your monitoring software to understand 9i
>>
>>
>An no - it is *NOT* a good idea to offline
>that one... It's used internally by DDL statements, afaik
>And by the time you understand 9i, you do not need this
>monitoring s/w... :)

Thanks for your help. I found some good information on the topic and changed our monitoring software too.

Vince
http://www.mgpmrc.org



Come race with us!
http://www.mgpmrc.org Received on Tue Feb 08 2005 - 10:26:12 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US