Re: Qualitative method for performance effect of Oracle triggers

Robert Roh wrote:

> We are studying the use of triggers on a system that expects 100,000
> records over a 10 hours period.
>
> Is there any way to measure the performance effect in a qualitative
> formulaic way as opposed to knowing that there will be some
> performance effect which you won't know until you test it
>
> Thanks
> Robert

In addition to Miss (or is it Mrs. ? ;-) ) Dent's reply. The best way to evaluate the impact of triggers is to run DBMS_PROFILER.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)