Re: Possible Tune-up?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 27 Jul 2006 07:18:24 +0200
Message-ID: <50jgc2lbcdg4lg1k1h3aqkbmknadu5fo9k@4ax.com>

On 26 Jul 2006 21:19:18 -0700, "Adley" <adley194_at_gmail.com> wrote:

>Is there something wrong with the PL/SQL script above?

Sure there is.You are executing procedurally what should have been done non-procedurally (ie one update statemnt with a subquery). As you have torn things apart, you force Oracle to fetch one record at a time. This is slow. Also you force Oracle inside the loop from the PL/SQL engine to the SQL engine. This is called a context switch and is also costly.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Jul 27 2006 - 00:18:24 CDT