Re: Rollback Segment Status 'PENDING OFFLINE'

Unless you are hitting a bug there is an active process assigned to the rollback segment. May I suggest you one try to use the 'alter rollback segment r07 shrink;' to free the unused allocated segments. As far as finding the active process look for any daemon type Oracle batch jobs your application has, processes started by dbms_job, and if you have distributed queries any pending queries.

If this does not work and if the segment was built as a private rollback segment remove the segment from the init.ora and bounce the system again.

Good luck.

Arthur Chung <arthur.chung_at_interactive.rnb.com> wrote in article <36703359.6B5CB8E7_at_interactive.rnb.com>...
> I'm running Oracle 8.0.4 on Solaris 2.6 env.
>
> One of the rollback space has gotten status FULL and I wanted to bring
> it down ( I wanted to drop that rollback space ).
>
> When I gave the command, 'alter rollback segment r07 offline',
> instead of going offline directly, status changed to 'PENDING OFFLINE'
> ... so far so good...
> but it stayed that way for many hours.. and I don't think it will ever
> change.
>
> I did shutdown the database properly but it comes backup clean to ONLINE
> status and whenever I try to take it offline, I again get same 'PENDING
> OFFLINE'.
>
> What could be the issue that's holding this up?
> Is there any way to force the system so that rollback space goes to
> OFFLINE status?
>
> Any info would be appreciated!
> -Arthur
>
>
>
Received on Fri Dec 11 1998 - 08:27:07 CST