Re: snapshot to lod help!!!

From: <michael_bialik_at_my-deja.com>
Date: Thu, 13 Jan 2000 20:51:41 GMT
Message-ID: <85ldsn$i09$1@nnrp1.deja.com>

Hi.

I would like to see more info but there are a number of possibilities:

"Brute force approach" - increase your rollback segment size ( multiply the existing size by 10**n ) and use SET TRANSACTION to get that rollback segment at execution time.
- I don't like that one.
Is your problem arises during UPDATE or SELECT? If you are running SELECT - try to optimize the SQL statement in order to cut execution time. If you are updating inside CURSOR loop - you will have to close the main cursor from time to time and re-open it again ( COMMIT inside cursor loop does NOT help ! )

HTH. Michael.

In article <387E0301.8ED4CAEA_at_sympatico.ca>, Serge Nantel <snantel_at_sympatico.ca> wrote:
> Anyone no how to fix this error snapshot to old????
>
> snantel_at_mei.ca
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 13 2000 - 14:51:41 CST