Re: loss of performance when using anonymous pl/sql blocks?!
Date: 16 Oct 2003 07:45:20 -0700
Message-ID: <1efdad5b.0310160645.e558655_at_posting.google.com>
Markus Breuer <markus.breuer_at_gmx.de> wrote in message news:<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
why dont you run it and find out? Oracle will still cache it. This shouldnt have any effect on performance. Received on Thu Oct 16 2003 - 16:45:20 CEST