CODEWITHSUNDEEP
oracle-databaseunix
satheesh v
satheesh v

Reputation: 55

Query takes too much time to process

I just need an approach for this question. Our application connects to Oracle database. It is running fine in production but occasionally some queries take too much time to process (like 5-7 seconds). Sometimes they are update queries and sometimes select queries. I just want to know how to approach such issues, any tools like nmon would help. Thanks.

Upvotes: 0

Views: 165

Answers (1)

BobC
BobC

Reputation: 4416

90% or more of poor performing queries come down to the execution plan. And probably 90% of those are related to statistics. The place to start would be to get a SQL Monitor report, which will show you the execution plan, together with runtime statistics and identify where time is being spent. Only when you understand the problem, can you come up with the correct solution. If you are not familiar with SQL Monitor, check out http://www.oracle.com/technetwork/database/manageability/sqlmonitor-084401.html

Upvotes: 1

Related Questions