Re: page_in values in vmstat output

From: mkbobba <member25475_at_dbforums.com>
Date: Mon, 24 Feb 2003 15:28:42 +0000
Message-ID: <2567246.1046100522@dbforums.com>

Originally posted by Da Morgan
> Bob wrote:
>
> > DA Morgan wrote in message news:news:...
> > 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

This is the copy of my /etc/system file:

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=1024
set shmsys:shminfo_shmseg=1024
set semsys:seminfo_semmns=16384
set semsys:seminfo_semaem = 16384
set semsys:seminfo_semmni = 1024
set semsys:seminfo_semmap = 1026
set semsys:seminfo_semmsl = 100
set semsys:seminfo_semopm = 100
set semsys:seminfo_semmnu = 2048
set semsys:seminfo_semume = 256
set msgsys:msginfo_msgmap = 1026
set msgsys:msginfo_msgmax = 4096

* BEGIN RAID Manager addition
* DO NOT EDIT from BEGIN above to END below...

forceload: drv/sd
forceload: drv/rdnexus
forceload: drv/rdriver

* END RAID Manager addition
* Begin MDD root info (do not edit)

forceload: misc/md_trans
forceload: misc/md_raid
forceload: misc/md_hotspares
forceload: misc/md_stripe
forceload: misc/md_mirror
forceload: drv/sbus
forceload: drv/fas

rootdev:/pseudo/md_at_0:0,10,blk
* End MDD root info (do not edit)
* Begin MDD database info (do not edit)

set md:mddb_bootlist1="sd:555:16 sd:555:1050 sd:556:16 sd:556:1050
sd:603:16"
set md:mddb_bootlist2="sd:603:1050 sd:604:16 sd:604:1050"

* End MDD database info (do not edit)

--
Bob


Posted via http://dbforums.com

Received on Mon Feb 24 2003 - 09:28:42 CST