Re: Shared Memory Parameters?
From: "Calvin Shoults" <jcsatlcom.net@mindspring.com>
>
>I am working with an existing database that has some onconfig parameters
>that I am questioning.
>
>One of our problems is extents, but another reason we get hammered during
>the day might be the following shm parameters.
>
>OL Engine Vers. 7.31 on HP 9000
>Aprx. 400-600 users
>Database - 14 gig
>6 - CPUS
>21 chunks used for database
>
># Locks - 200,000
># Buffers - 300,000
># NUMAIOVPS - 56
># PHYSBUFF - 1024
># LOGBUFF - 128
># LOGMAX - 50
># CLEANERS - 22
># SHMVIRTSIZE - 1,400,000
># SHMADD - 131,072
># SHMTOTAL - 0
># LRUS - 56
># LRU_MAX_DIRTY - 5
># LRU_MIN_DIRTY - 2
># STACKSIZE - 32
>
>I am considering changing to
>
># Buffers - 2,000
You're mad. You have 600 users hammering away and you want to *decrease*
buffers?
># LRUS - 50
># LRU_MAX_DIRTY - 60
># LRU_MIN_DIRTY - 50
># CLEANERS - 8
I like to have one more CLEANER than LRUS. I'd go with 57 and 56,
respectively.
Can we get output from
onstat -p
onstat -F
onstat -R
onstat -g iov
onstat -d
and your full onconfig file?
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com