Re: How to tune database with lots of very light queries

How much time is spent parsing. What is your execute to parse ratio? Is there any difference in the resource usage of your queries. Are you using ³shared servers²? Is it one query per session? Just some things to think about.

On 4/29/08 9:30 AM, "Frits Hoogland" <frits.hoogland_at_gmail.com> wrote:

> Starting point should still be looking at where your database is waiting at,
> and how the waits relate to CPU usage.
>
> Then pick the biggest component (either CPU or a wait), and see how that can
> be decreased.
>
> frits
>
> On Tue, Apr 29, 2008 at 4:58 PM, Zhu,Chao <zhuchao_at_gmail.com> wrote:

>> 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