Re: Convert PLSQL update with forall

From: amonte <>
Date: Sun, 20 May 2018 23:30:37 +0200
Message-ID: <>

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 <>:

> 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

Received on Sun May 20 2018 - 23:30:37 CEST

Original text of this message