There could be a problem in the memory itself.
The database is on raw devices and here is /etc/system:
- vxfs_START -- do not remove the following lines:
*
- VxFS requires a stack size greater than the default 8k.
- The following values allow the kernel stack size
- for all threads to be increased to 16k.
*
set lwp_default_stksize=0x4000
set rpcmod:svc_run_stksize=0x4000
- vxfs_END
- ESS_Standard_Start (do not remove)
- Set max network logins to 200
set pt_cnt=200
set npty=200
- Disable IP grouping
set ip:ip_enable_group_ifs=0
- Re-map the Break key to ^\
- not on E10K domains
set zs:SUNIzsbrk_breakchar = 0x1c
set zs:SUNIzsbrk_count = 1
*EMC settings
set sd:sd_max_throttle=20
set scsi_options=0x7F8
set sd:sd_io_time=0x78
set red_minavail=7000
* ESS_Standard_End (do not remove)
- 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/isp
forceload: drv/sd
rootdev:/pseudo/md_at_0:0,0,blk
- End MDD root info (do not edit)
- Begin MDD database info (do not edit)
set md:mddb_bootlist1="sd:63:16 sd:63:1050 sd:63:2084 sd:183:16 sd:183:1050"
set md:mddb_bootlist2="sd:183:2084 sd:87:16 sd:87:1050 sd:87:2084"
- End MDD database info (do not edit)
- vxvm_START (do not remove)
forceload: drv/vxdmp
forceload: drv/vxio
forceload: drv/vxspec
- vxvm_END (do not remove)
- semaphore settings added 10/25/99 - AS
set shmsys:shminfo_shmmax=1048576000
set semsys:seminfo_semmap=10240
set semsys:seminfo_semmni=2816
set semsys:seminfo_semmns=15360
set semsys:seminfo_semmsl=1024
set semsys:seminfo_semmnu=6192
set semsys:seminfo_semume=4096
set semsys:seminfo_semopm=256
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=256
set msgsys:msginfo_msgmnb=262144
set msgsys:msginfo_msgtql=4096
set msgsys:msginfo_msgmap=7680
set msgsys:msginfo_msgssz=512
set msgsys:msginfo_msgmax=65535
set msgsys:msginfo_msgseg=16384
set msgsys:msginfo_msgmni=5120
set shmsys:shminfo_shmseg=200
- end semaphore/msg settings
- Set hme0 to 100MB Full Duplex
set hme:hme_adv_autoneg_cap=0
set hme:hme_adv_100T4_cap=0
set hme:hme_adv_100fdx_cap=1
set hme:hme_adv_100hdx_cap=0
set hme:hme_adv_10fdx_cap=0
set hme:hme_adv_10hdx_cap=0
-----Original Message-----
From: Gogala, Mladen [mailto:MGogala_at_oxhp.com]
Sent: Monday, June 12, 2000 3:01 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Sun Memory Upgrade problem
Did you re-tune the OS? Anything done with SWAP, parameters? are you sure
that
the installed RAM itself isn't slow? Can you post your /etc/system?
-----Original Message-----
Sent: Monday, June 12, 2000 1:04 PM
To: Multiple recipients of list ORACLE-L
Hi,
After we upgraded memory on Sun 4500 to 10Gb Oracle performance became very
bad.
It is almost 50% slower.
Any ideas?
Also when the sessions parameter becomes high like 4000, setting autotrace
on in sqlplus becomes very very slow.
Received on Mon Jun 12 2000 - 14:36:54 CDT
