Re: page_in values in vmstat output

Just for comparison:

You have set shmsys:shminfo_shmmni=1024 and the documentation indicates 100
You have set shmsys:shminfo_shmseg=1024 and the documentation indicates 10
You have set semsys:seminfo_semmni = 1024 and the documentation indicates 100
You have set semsys:seminfo_semmns=16384 and the documentation indicates 200
Documentation indicates set semsys.seminfo_semvmx=32767 and you have nothing

I'm not saying any of this is the cause ... but I'd go back to basics and verify that these settings don't help before proceeding.

Daniel Morgan

mkbobba wrote:

> 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 - 11:11:30 CST