Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trigger Performance

Trigger Performance

From: TimKArnold <timkarnold_at_aol.com>
Date: 24 Jan 1999 15:47:11 GMT
Message-ID: <19990124104711.19991.00002128@ng-ft1.aol.com> 





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 Sun Jan 24 1999 - 09:47:11 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US