topic Open cursor recommend package size in Application Development and Automation Discussions

Open cursor recommend package size

former_member745956 — Tue, 11 May 2021 07:55:30 GMT

What should be the correct package size, given the number of rows in the table and its width?

The question is related to the appearance of the error: "SQL message: ORA-01555: snapshot too old". If fetch line by line, will it be better?

Re: Open cursor recommend package size

matt — Tue, 11 May 2021 09:55:40 GMT

There is no definitive answer. It depends on too many variables. If a package size of 100'000 is too big, try 10'000 etc.

Re: Open cursor recommend package size

Sandra_Rossi — Tue, 11 May 2021 12:44:53 GMT

That usually happens because the table is updated at the same time by another process which updates a lot and commits rarely. Try to find out what job was running at the same time.