Why the same sql operation have peak response time
Posted by:
Conan Gao
Date: July 14, 2008 11:07PM
Why the same operation can have peak response time,not only for write but also for read when I execute the same sql statement many times like 5000 times in a java loop.
From my testing, the average time for search a table named call_log is 52 ms, but the longest time is 3091 ms. And the same things happened on update, delete and insert call_log.
Who can tell me the reason of this issue?
Thanks!
Subject
Views
Written By
Posted
Why the same sql operation have peak response time
2975
July 14, 2008 11:07PM
2076
July 15, 2008 01:00AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.