I am facing a performance problem with an INSERT statement inserting records in one transaction table. The table has around 20 columns and all are NOT NULL columns. It has seven indexes and many constraints. There are many concurrent inserts happening (maybe around 1,000 concurrent inserts).
We have run the database performance health check script obtained from Metalink (Note:1019592.6) and tuned accordingly. The problem still occurs. We don't have the SQL trace or explain plan of the statement and it is difficult to get as it's a production system. The table and indexes are analyzed and statistics are up to date.
Following is an entry obtained from Statspack:
Physical reads: 101,419 Executions: 129,699 Reads per Execution: 0.8 % Total: 0.1The Oracle database version is 220.127.116.11.
I know the information provided is not enough but this is what I have now from the customer. Any help will be greatly appreciated.
Dig Deeper on Oracle and SQL
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.