Re: Trigger Performance

From: Maxim A Sokolnikov <max_at_mpsb.moris.rosmail.com>
Date: Mon, 25 Jan 1999 00:50:45 +0000
Message-ID: <36ABBFE5.99E0516E@mpsb.moris.rosmail.com>

TimKArnold wrote:

> Hi,
>

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

Because of trigger compilation each time when it fiered, try to rewritetrigger body using stored procedures calls where it possible.

Maxim.

> TIA,
> Tim
Received on Sun Jan 24 1999 - 18:50:45 CST