troubleshooting Question

How to convince somebody it's not the oracle

Avatar of Geert G
Geert GFlag for Belgium asked on
Oracle DatabaseDelphi
20 Comments4 Solutions384 ViewsLast Modified:

I have this problem of trying to explain to some people they are wrong.

Here is the situation:
Biztalk app starts transactions on a oracle database.
first command: alter session set isolation level serializable
next: they (update) set a flag in a record they will be processing a record (they don't state which record or who is processing)
next: start reading records
next: they insert processed records
next: commit

they do this with 15 sessions at once

they say they have connection pooling set up, but every time sessions are closed and reopened for a new loop

how would you explain to them that of the 45 minutes they need to process 200000 records
there is no point in tuning the 13 seconds oracle is busy with the reads and the inserts.

based on tkprofs results 13 seconds was the time spent by the oracle database, the rest was because of SQL*net wait client
David VanZandt
Sr Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 4 Answers and 20 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 20 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros