Re: How to tune database with lots of very light queries
From: Frits Hoogland <frits.hoogland_at_gmail.com>
Date: Tue, 29 Apr 2008 18:30:19 +0200
Message-ID: <fbb8fbcd0804290930q75408a65tad552329b82f25e6@mail.gmail.com>
Date: Tue, 29 Apr 2008 18:30:19 +0200
Message-ID: <fbb8fbcd0804290930q75408a65tad552329b82f25e6@mail.gmail.com>
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.
>
> --
> Regards
> Zhu Chao
> www.cnoug.org
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Apr 29 2008 - 11:30:19 CDT