spremuta_at_gmail.com wrote:
> Vladimir M. Zakharychev ha scritto:
>
>> And what the application is doing when you're getting the error? Does
>> it happen to fetch something from a big result set in a loop and commit
>> inside this loop? Or does it happen that the query runs longer than
>> specified undo retention period (10800 seconds is 3 hours,) while
>> there's a lot of transactional activity in the db?
>>
>> Regards,
>> Vladimir M. Zakharychev
>> N-Networks, makers of Dynamic PSP(tm)
>> http://www.dynamicpsp.com
>
>
> Is there a fetch into a cursor declaration, in a sql script that
> somethimes is long 4-6 hours....
> in a table there are about 90milions of records.....
Post the PL/SQL that is causing the 1555.
--
Daniel Morgan
University of Washington
Puget Sound Oracle Users Group
Received on Tue Sep 12 2006 - 08:34:22 CDT
