Re: PL/SQL cursor

From: Alexey E. Neckrasow <nec_at_leaves.spb.su>
Date: 1997/03/27
Message-ID: <333A5C48.370A_at_leaves.spb.su>#1/1


ttran_at_ssofa.com wrote:
>
> Could anyone explain to us where does the PL/SQL cursor data stored?
> is it in the SGA or else where?
>
> Our archived/purge script looks something like this:
> For C1 in Cursor_1
> Loop
> Process data (insert into archive tables and delete from tables)
> commit;
> End Loop;
>
> Notice: the commit command is in the loop. Also this script constantly
> getting error: Snapshot too old and rollback segment too small.
>
> Thanks in advance, any help will be appreciated.
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

My advice may seems quite bizzare but try to do commits less often.

When you commits too often, it can lead to 'fetches across commits'.

-- 
Regards. Alexey Neckrasow. Leaves Inc. Russia.
e-mail: nec_at_leaves.spb.su
Received on Thu Mar 27 1997 - 00:00:00 CET

Original text of this message