Re: Trigger Performance

From: RP Data Solutions <rpdata_at_cyberus.ca>
Date: Sun, 24 Jan 1999 21:18:38 GMT
Message-ID: <36ab8d28.154956515@news.cyberus.ca>

How large are these triggers???
You may want to transfer the logic to a procedure that can be called from the trigger.. A trigger is compiled every time you execute it whereas a procedure does not... Depending on the size on the PL/SQL within the trigger this could really help performance......

Good Luck

Robert Prendin
timkarnold_at_aol.com (TimKArnold) wrote:

>Hi,
>
>I'd like to improve the performance of a
>group of triggers. I tried dbms_shared_pool.keep ('my_trigger')
>to pin the trigger to memory, but apparently it only
>works for packages. If 'alter table my_table cache' that
>helps.
>Any suggestions?
>
>TIA,
>Tim

Robert Prendin
RP Data Solutions Inc.
Specializing in ORACLE DBA Support Services Received on Sun Jan 24 1999 - 15:18:38 CST