Re: Server Hit Ratio

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 2 Dec 2000 20:08:43 +0100
Message-ID: <90bj51$jeeg$2@ID-62141.news.dfncis.de>

"MT" <mtmail_at_netvigator.com> wrote in message news:90b6kd$55g5_at_imsp212.netvigator.com...
> Hi, could anyone help me is there any method to increase the
> server hit ratio say from .85 to .90 besides increase db_buffer_cache
size.
>
> Thanks.
>
>

There is no other method, or you should tune all your statements to reduce the number of full table scans, lol

Regards,

Sybrand Bakker, Oracle DBA Received on Sat Dec 02 2000 - 13:08:43 CST