Re: How to clear Rollback segments

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 03 Dec 2001 23:27:44 GMT
Message-ID: <3c0c0a27.276776143@news.globix.com>

what do you mean by clean?

u can search for xactions that are using it and kill 'em (i do this for old xactions that seem to be 'blocking' the rollback from growing, collect the SQL they have open and forward it to developers)

On Mon, 3 Dec 2001 22:53:12 +0100, "Michael Buresch" <michael.buresch_at_t-online.de> wrote:

>Hallo,
>
>I have very big system rollback segments. How can I clean or reset it. My
>system is very slow and it seems that that is the problem.
>
>Best regards,
>Michael
>
>

.......
We use Oracle 8.1.6-8.1.7 on Solaris 2.6, 2.7 boxes

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Mon Dec 03 2001 - 17:27:44 CST