| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: system rollback segments
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
 |
 |