Re: Convert PLSQL update with forall

Hello Andy

The SQL takes around 1 hour, the updates takes around another 2000 seconds or so. I will check the recommendations from Jacek, Pawel and Vikas. Look promising.

Thank you

2018-05-20 23:14 GMT+02:00 Andy Sayer <andysayer_at_gmail.com>:

> What sort of timings are you actually getting here and what do you need to
> be getting?
>
> Have you looked into where the time is really going? The performance
> impact of 2 million (*2) context switches isn’t negligable but it’s not
> going to turn something from way too slow to okay.
>
> How long does the SQL in your for cursor take to execute and fetch 2
> million results?
> How long does one individual update take? Have you looked at the execution
> plan of that?
>
> Are you updating a table that you are querying inside that loop? (Causing
> you to read undo you’ve just generated)
>
> Hopefully that gets us looking in the right direction,
> Andrew
>

--
http://www.freelists.org/webpage/oracle-l