Re: Trigger Performance

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Mon, 25 Jan 1999 11:21:48 +0800
Message-ID: <36ABE34C.25F4@bhp.com.au>

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

Take the code of your trigger - put it in a proc or pkg and pin that...

Cheers
C.
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Sun Jan 24 1999 - 21:21:48 CST