Re: Oracle 7.2.3 suddenly excessive cache buffer misses???

gmayes_at_pch.com wrote:
>
> Platform AIX 4.1.4 Oracle 7.2.3
> Suddenly any decent sized query thrashes the disks and drives the system
> to 100% utilization!!! and doesn't return. At the same time regular
> transtions run fine. Any Ideas???
> P.S. No changes have been made to the initialization parameters and
> database has been stable for 1.5 yearsLook at your minservers and maxservers in your AIX parameters. Also be
sure that you are utlizing all of your paging. There is also a possiblity that you have just grown beyond what the current settings could handle. Try increasing your db_block_buffers to see if this will help. You may also want to look at your shared_pool_size. These things will grow.

Are you using cost-based? If so , how recently have you updated your statistics?

-Sheilah Scheurich
DBA
to respond via email remove the underscores. Received on Mon Sep 29 1997 - 00:00:00 CDT