Re: Insert/Update performance issues with Oracle 10gR2 + DBI + DBD::Oracle

2006-11-08 Thread John Scoles
I would have to agree with Ron on this that is it someting in your Oracle that is going awry. Perhaps you are missing an index someplace. Looking at the code trace you included there is nothing in DBD::Oracle 1.18 that has changed in what you are hitting since 1.16. Can you try using

RE: Insert/Update performance issues with Oracle 10gR2 + DBI + DBD::Oracle

2006-11-07 Thread Reidy, Ron
Have you performed a 10046 trace? What (if any) init parameters were changed prior to moving to 10g? Do you have up to date CBO stats on your tables and data dictionary? -- Ron Reidy Lead DBA Array BioPharma, Inc. -Original Message- From: Sanjay Noronha [mailto:[EMAIL PROTECTED] Sent: