Home -> Usenet -> comp.databases.oracle -> loss of performance when using anonymous pl/sql blocks?!

loss of performance when using anonymous pl/sql blocks?!

From: Markus Breuer <markus.breuer_at_gmx.de>
Date: Wed, 15 Oct 2003 14:00:47 +0200
Message-ID: <3F8D36EF.4090309_at_gmx.de> 






Instead of using a set of different sql-statements i have decided to use 
an single, anonymous pl/sql block with host-variables. For example:



DECLARE



  cmp   NUMBER := :hostvariable;


BEGIN



    UPDATE t_sample SET c_id=0 WHERE tid>cmp;
END;


Are there any disadvantages concerning simle update-statement?
Won't oracle cache such blocks, do they need more processing time or 
more cpu-power on the server? Or does oracle treat them as any other
sql statement?



thx, markus
Received on Wed Oct 15 2003 - 14:00:47 CEST












Original text of this message