Re: Trigger Performance

Hi Tim,

Try
execute dbms_shared_pool.keep ('my_trigger','R');

Regards,
Eugeny.

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
Received on Mon Jan 25 1999 - 01:37:21 CST