Re: Poor Performance on Oracle9i - 9.2.0.7

From: eavanzi <eavanzi_at_romi.com.br>
Date: 8 May 2006 05:39:54 -0700
Message-ID: <1147091994.463394.134220@j33g2000cwa.googlegroups.com>

Hi!
The /etc/system parameters in my Solaris 2.6 are:

set maxpgio=65536
set autoup=30
set slowscan=500
set maxusers=2048
set sd:sd_max_throttle=20
set sd:sd_io_time=120
set maxphys=8388608
set rlim_fd_cur=512
set rlim_fd_max=4096
set priority_paging=1

forceload: drv/sd
forceload: drv/SUNW,fas
forceload: drv/sbus
forceload: drv/ssd
forceload: drv/sf
forceload: drv/pln
forceload: drv/soc
forceload: drv/socal
forceload: drv/SUNW,socal
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=4096
set shmsys:shminfo_shmseg=200
set semsys:seminfo_semmns=600000
set semsys:seminfo_semmni=4096
set semsys:seminfo_semmsl=4096
set semsys:seminfo_semmap=600000
set semsys:seminfo_semmnu=600000
set msgsys:msginfo_msgmap=600000
set msgsys:msginfo_msgmax=6144
set msgsys:msginfo_msgmni=640
set msgsys:msginfo_msgssz=64
set msgsys:msginfo_msgtql=640
set msgsys:msginfo_msgseg=32768
set semsys:seminfo_semopm=50

set semsys:seminfo_semume=40
set kobj_map_space_len=0x400000
set npty=256
set pt_cnt=256

forceload: drv/vxdmp
forceload: drv/vxio
forceload: drv/vxspec

rootdev:/pseudo/vxio_at_0:0
set vxio:vol_rootdev_is_volume=1

set ecache_scrub_enable=1
set ecache_scan_rate=1000
set ecache_calls_a_sec=100

Is it possible to grow the SGA?
Thank you. Received on Mon May 08 2006 - 07:39:54 CDT