Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Off-Line/On-Line Rollback segments question
If you have SQL Worksheet (as you wrote) than you can check the actual number of
rollback segments and parameters in init.ora file:
1. select * from dba_rollback_segs; (this will show you all rollback segments with
their status)
2. show parameter roll*; (this will show all of the entries in the init.ora that
contain "roll" string
hope this helps
Peter
gilhirsch_at_my-dejanews.com wrote:
> Hi,
>
> We've installed an oracle 7.3.3.X server at a remote site, and we ran into
> this weird situation, that I'm hoping someone can help me with.
>
> Keep in mind that the only access tools we have are the Oracle Enterprise
> Manager tools (Instance/Schema/Security/Storage Manager clients, and the
> Worksheet) over a TCP/IP link.
>
> Here's an overview of the situation:
> - We defined 17 (RB##) PUBLIC rollback segments.
> - All segments have been manually altered to be ONLINE
> - We altered the ROLLBACK_SEGMENTS parameter to include all RB##'s, and
> restarted the instance - ALL VIA INSTANCE MANAGER CLIENT, because currently
> we have no other way of getting our hands on the init.ora file.
> When re-accessing the Instance Manager, the new ROLLBACK_SEGMENTS value
> appears in the running value column.
> - All rollback segments were ONLINE after instance restart.
>
> Observed behavior (after a couple of days): - Only 5 of the defined RB##'s
> are ONLINE, the rest are OFFLINE. - When accessing the Instance Manager, the
> newly-entered definition of the ROLLBACK_SEGMENTS parameter has been changed
> back to NOTHING (default value).
>
> We have no reason to believe that anyone from the remote site has been
> altering our configuration, shutting down the instance, altering the
> rollbacks to OFFLINE state, or anything else we might think of. Based on that
> assumption, it's obvious that we're missing out on something...
>
> Please, if any of you gurus can enlighten us as to how to solve this situation
> - we need all of our 17 rollbacks ONLINE, all the time
> - does changing the ROLLBACK_SEGMENTS parameter from the Instance Manager
> client
> affects the init.ora, or is it a temporary change of some sort?
>
> Thanks,
> Gil.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Aug 20 1998 - 08:58:29 CDT