ED]]
> Sent: Thursday, February 20, 2003 7:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: slow update and db trigger
>
>
> It could also be a dynamic recompile issue. Make sure the triggers and
> proc. are valid before each
> test.
>
> Ron Thomas
&
]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: slow update and db
It sounds like the triggers / procedures may have different logic depending
on the row being updated. Or possibly the same logic results in a large
number of rows being queried / modified by one of the procedures.
Have you looked at the trigger and procedures to understand what they are
doing? T