Ravindra, The possibilities could be vary, but my curiosity, it's coming from your trigger database. My experience when using trigger database, it makes slow processes, so I never use it anymore.
Rgrds, Sony > -----Original Message----- > From: Ron Thomas [SMTP:[EMAIL PROTECTED]] > 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 > Hypercom, Inc > [EMAIL PROTECTED] > Each new user of a new system uncovers a new class of bugs. -- Kernighan > > > > > mrichard@transurb > > an.com.au To: > [EMAIL PROTECTED] > > Sent by: cc: > > [EMAIL PROTECTED] Subject: Re: slow update > and db trigger > > > > > 02/19/2003 05:28 > > PM > > Please respond to > > ORACLE-L > > > > > > > > > > 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? There may be opportunities to tune them. Perhaps you could trace > the session to see what is happening, but it might be easier to look at > the > code. > > Regards, > Mark. > > > > > "Basavaraja, Ravindra" > > <Ravindra.Basavaraja@T-M To: Multiple > recipients of list ORACLE-L > <[EMAIL PROTECTED]> > obile.com> cc: > > Sent by: Subject: slow > update and db trigger > > [EMAIL PROTECTED] > > > > 20/02/2003 10:41 > > Please respond to > > ORACLE-L > > > > > > > > I have an update statement executed by a procedure.This update statements > fires a trigger which has a set of update statements > and also executes 2 procedures. > > If i execute the parent update statement which will affect a single row > from a table which has significantly less number of rows.This statement > sometimes is executed very fast and sometimes it takes upto 50 > seconds.Does > this slowness got to do anything with the triggers that > get fired automatically .For me this update is a single piece of > transaction.Why do i see the delay in this update statements. > > Thanks > Ravindra > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Basavaraja, Ravindra > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > >>>>>> > Privileged/Confidential information may be contained in this message. > If you are not the addressee indicated in this message > (or responsible for delivery of the message to such person), > you may not copy or deliver this message to anyone. > In such case, you should destroy this message and kindly notify the sender > by reply e-mail or by telephone on (61 3) 9612-6999. > Please advise immediately if you or your employer does not consent to > Internet e-mail for messages of this kind. > Opinions, conclusions and other information in this message > that do not relate to the official business of > Transurban City Link Ltd > shall be understood as neither given nor endorsed by it. > <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<---->>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> > >>>>>> > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mark Richard > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Ron Thomas > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sony kristanto INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
