Re: buffer cache and shared pool size tuning

From: Jared Still <jkstill_at_gmail.com>
Date: Fri, 11 Dec 2009 09:57:42 -0800
Message-ID: <bf46380912110957t11541cd0kcd31b2db883f092_at_mail.gmail.com>

On Thu, Dec 10, 2009 at 6:46 PM, D'Hooge Freek <Freek.DHooge_at_uptime.be>wrote:

> Jared,
>
> Thank you for sharing the queries.
> But I'm looking for a more general method that is not looking to the
> advisory tables.
> Reason for this is that I think that the figures in the advisory are pushed
> higher because of a query that is executed every 10, 15 minutes and that is
> performing a full table scan on a 2 GB (and growing) table.
>
>

Well, that makes sense. The advisors seem to work well enough otherwise.

>
> ps) The vendor is writing a patch to deal with this problem query.
>
>

Lucky you. I found a similar problem some time back in a product (since acquired by Oracle)
that continually ran 3 different queries in the background, all FTS.

The solution was to wait for the next version.

That reminds me, I should check to see if they actually fixed it.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home Page: http://jaredstill.com

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 11 2009 - 11:57:42 CST