RE: unable to take rollback segment offline

Taking a rollback segment offline can take quite a while ... Especially if it is heavily used.

Though excluding it in the init.ora doesn't sound like a good idea to me. You can't take something offline when it hasn't been put online by Oracle at startup.
But then again, excluding it in the init.ora AFTER the startup doesn't have any effect at all.

Last remark : When a rollback segment has been put OFFLINE, the status simply reads OFFLINE. If not mistaking PENDING OFFLINE is only during the period Oracle is waiting for all current transactions in that rollback segment to complete.

Hope this info helps.

Greets,

Kirsten

> -----Original Message-----
> From: Indra Harimurti [SMTP:indra_at_sofrecom.co.id]
> Sent: Wednesday, August 23, 2000 11:16 AM
> To: Multiple recipients of list ORACLE-L
> Subject: unable to take rollback segment offline
>
> Dear List,
>
> Oracle 7.3.4 Digital Unix 4.0d
> try to make rollback segment offline but always
> failed even after the instance is restarted.
>
> have done these steps :
> 1. restart the database
> 2. exclude in init.ora
> 3. check using : select name,xacts
> from v$rollname,v$rollstat
> where status = 'PENDING OFFLINE'
> and v$rollname.usn=v$rollstat.usn;
> No Rows Selected
>
> but STILL it can not be put offline, what else need to be done ?
> Please help. Thanks
Received on Wed Aug 23 2000 - 06:21:26 CDT