Re: rollback segment

From: andrew_webby at hotmail <root_at_127.0.0.1>
Date: Thu, 16 Nov 2000 13:32:44 -0000
Message-ID: <974381578.5344.0.nnrp-12.c30bdde2@news.demon.co.uk>

If you've restarted the database and don't have any daemons or batch processing claterring away, simply drop the segment and recreate it...

<daud11_at_hotmail.com> wrote in message news:8uvb74$761$1_at_nnrp1.deja.com...
> I have a rollback segment where about half the size is in use (100++Mb).
> I am not sure which session is using it...and I dont think it should go
> up to that much. I restarted the database hoping that whatever that is
> using it would release it. Upon start up I found that the same amount
> of size is in use. How do I check what's using the rollback segments
> and how do I terminate if I need to?
>
> Thanks
> Daud11
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 16 2000 - 07:32:44 CST