Re: page_in values in vmstat output

Bob wrote:

> DA Morgan <damorgan_at_exesolutions.com> wrote in message news:<3E469A94.EAE132FD_at_exesolutions.com>...
>
> Please see embedded answers.
>
> >
> > Are the kernel parameters /etc/system configured for a single Oracle
> > instance or for all four?
>
> kernel parameters in /etc/system is configured for all four instances.
>
> > 32bit or 64bit?
>
> Solaris 64 bit and oracle 32 bit.
>
>
> > What version and edition of Oracle?
>
> Oralcle 8.1.7.0.0
>
> > Are statistics kept current with DBMS_STATS?
>
> Statistics for only selected tables and indexes are kept up to date
> with direct analyze commands, weekly twice.
>
> I can see lot of IO related waits in STATSPACK report(dbfile scattered
> read,dbfile sequential read tops the waits). But how these are related
> to the paging of the server?.
>
> > Have you isolated the problem to the database and not the middle-ware?
>
> Yes. The problem is isolated to the database.
>
> >
> > Daniel Morgan

I'm still thinking the problem is in /etc/system and your mixing of 32bit and 64bit implementations. If no one else gives you a better answer ... post your system file.

Daniel Morgan Received on Wed Feb 12 2003 - 23:10:43 CST