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?
]
Sent by: cc:
[EMAIL PROTECTED] Subject: Re: slow update and db
, 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
Hypercom, Inc
[EMAIL PROTECTED]
Each new user