RE: Sun Memory Upgrade problem

We have 4500 "panic" several times including this morning and last Friday. Do you think the problem was caused by the maximum physical I/O size parameter. We have 8192M real memory. Is the following maxphys in /etc/system too big?
* FCAW

    set maxphys = 8388608

Thanks.
Linda
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Khedr, Waleed
Sent: Monday, June 12, 2000 2:46 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Sun Memory Upgrade problem

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-----
Sent: Monday, June 12, 2000 3:01 PM
To: Multiple recipients of list ORACLE-L

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.
For example select * from dual takes like two minutes.

Thanks,

Waleed

--
Author: Khedr, Waleed
  INET: Waleed.Khedr_at_FMR.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may