Q
Problem solve Get help with specific problems with your technologies, process and projects.

Too many reads on inserts

I have a third-party C++ app running on Oracle 10.2.0.2 and making OCI 9 calls. One of my major problems is that I have a lot of reads on inserts.

Hello, Phillip, and welcome to this wonderful forum! We would really appeciate your help. My question is: I have a third-party C++ app running on Oracle 10.2.0.2 and AIX 5.2 making OCI 9 calls. One of my major problems is that I have a lot of reads on inserts. (The application is heavy OLTP and it is not very well-designed, but I could always make suggestions to the dev team to change it for me.) So, I see a lot of reads on inserts. What I have is: very limited number of indexes, no FK, no triggers or anything that might slow down the inserts. How could I approach this problem and find some type of resolution?

That is hard to say without looking at a trace of the session or a statspack report. It could be that the application is doing an 'insert into table_a select ... from table_b'. If auditing is enabled, depending on the level of auditing, that can cause extra I/O as well.

The best way to track this down is to enable a trace on the session in question. The trace will capture any and all SQL that is run during that session. Then use the tkprof utility to format the trace file generated from your session so that it is easier to read. From there you should be able to identify what is causing the problem.

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close