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 -> Re: Qualitative method for performance effect of Oracle triggers

Re: Qualitative method for performance effect of Oracle triggers

From: Anna C. Dent <anacdent_at_hotmail.com>
Date: Sat, 15 Nov 2003 14:21:36 -0800
Message-ID: <QFxtb.16310$Q64.8855@fed1read03> 





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




No, because it depend directly exactly what gets done within the 
trigger(s). The more action which is done the greater the impact.
Received on Sat Nov 15 2003 - 16:21:36 CST












Original text of this message













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