How to tune database with lots of very light queries
Date: Tue, 29 Apr 2008 22:58:01 +0800
We have some databases with load profile like lots of light query (mostly pk based), each execution cost only 3-6 buffer_gets and no complex join etc.
But due to excessive executions (10K+ query per second), load is also driving pretty high.
Anyone has experience tune such kind of application/database? From single SQL point of view, they are already perfect.
http://www.freelists.org/webpage/oracle-l Received on Tue Apr 29 2008 - 09:58:01 CDT