Re: help: oracle 8.0.6 server on aix 4.3.3

How much physical memory does it have?

We have a similar setup and just spent today upgrading the server from 2GB to 3GB. Ever since we went live 2 weeks ago, the server has spent at least half its CPU time reading and writing to paging space. We've learned that Oracle8 is a serious memory hog.

Uwe Steffen wrote:

> We have currently two problems we are unable to solve, even using
> oracle-support and our own (bull) support:
>
> A number of database sessions hangs with 'buffer busy wait'. This occurs
> randomly
> after 1-7 days of stable operation. There is another session running a
> 'db file scattered read' on the same database block, wich does not
> return. The only solution
> so far is to restart the server.
>
> The second problem is the very high system load (ca.40%) regardles of
> user load
> on the server.
>
> The configuration is:
> - 4-ppc604-300 MHz cluser runnig aix 4.3.3
> - mirrored raid
> - oracle 8.0.6.0, databse installed in filesystem
> - asynchronuos IO is enabled for aix (fastpath enabled), but not for the
> database
> (DISK_ASYNCH_IO=FALSE)
>
> The problem (1) orrurred repeatedly on different servers using the same
> software,
> but also without raid.
> In the beginning we had DISK_ASYNCH_IO=TRUE and fastpath enabled,
> then DISK_ASYNCH_IO=TRUE and fastpath disabled, then
> DISK_ASYNCH_IO=FALSE and fastpath enabled, but nothing seems to help.
>
> Is there anyone else who experienced the problem(s) before?
>
> Uwe Steffen
> Bull GmbH
> u.steffen_at_bull.de
Received on Sun Oct 15 2000 - 21:52:43 CDT