Re: page_in values in vmstat output

From: Bob <mkbobba_at_yahoo.com>
Date: 12 Feb 2003 04:51:55 -0800
Message-ID: <64713ce9.0302120451.41e199de@posting.google.com>

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
Received on Wed Feb 12 2003 - 06:51:55 CST