From: vivek sharma (vivek_sharma_1@hotmail.com)
Date: Thu Oct 24 2002 - 14:06:42 EDT
/etc/system on DB Server of SF15000 machine attached :-
exclude: drv/ohci
* 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=0x8000
* vxfs_END
* vxvm_START (do not remove)
forceload: drv/vxdmp
forceload: drv/vxio
forceload: drv/vxspec
forceload: drv/sd
forceload: drv/scsi
forceload: drv/pci
forceload: drv/ssd
rootdev:/pseudo/vxio@0:0
set vxio:vol_rootdev_is_volume=1
* vxvm_END (do not remove)
* 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 nfs threads to be increased to 16K.
*
set rpcmod:svc_default_stksize=0x8000
* vxfs_END
*** Entries for XP-512 **
*forceload: drv/jnic
****set sd:sd_max_throttle=15 **** Changed by Sunadmin 210902 ****
set sd:sd_max_throttle=8
set sd:sd_io_time=0x3c
set maxphys=8388608
forceload: sys/shmsys
forceload: sys/semsys
set semsys:seminfo_semmni=60000
set semsys:seminfo_semaem=16384
set semsys:seminfo_semmap=700000
set semsys:seminfo_semume=100
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semmsl=215
set semsys:seminfo_semmnu=10000
set semsys:seminfo_semmns=100000
set semsys:seminfo_semopm=100
set shmsys:shminfo_shmmax=25769803776
set shmsys:shminfo_shmseg=200
set shmsys:shminfo_shmmin=2
set shmsys:shminfo_shmmni=5000
set c2audit:audit_load=1
set rlim_fd_max=8092
set rlim_fd_cur=8092
set maxuprc=20000
****set maxusers=1500 ***** Changed by sunadmin 170902 ****
set maxusers=2048
set shmsys:share_page_table=1
set tcp:tcp_conn_hash_size=262144
set autoup=900
*****set tune_t_fsflushr=1 changed by Sunadmin on 18/10/02 ****
set tune_t_fsflushr=32
set bufhwm=8000
set TS:ts_sleep_promote=1
**** FOR MAKING QFE 100MBPS FULL DUPLEX ****
set qfe:qfe_adv_autoneg_cap=0
set qfe:qfe_adv_100T4_cap=0
set qfe:qfe_adv_100fdx_cap=1
set qfe:qfe_adv_100hdx_cap=0
set qfe:qfe_adv_10fdx_cap=0
set qfe:qfe_adv_10hdx_cap=0
>
>-----Original Message-----
>From: vivek sharma [mailto:vivek_sharma_1@hotmail.com]
>Sent: Wednesday, October 23, 2002 2:41 PM
>Hi
>
>Much Higher CPU Utilization on DB Server Occuring after Moving to Sun Fire
>(SF) 15000 machine (24 CPUs @ 900 MHz) from Sun Fire(SF) 6800 machine ( 24
>CPUs @ 750 MHz ) . CPU Utilization increased by 15 %.
>
>The Storage Box Containing Oracle Software & Database [ Hybrid Banking
>Application ]was simply UNPlugged from the SF 6800 machine & plugged to the
>SF 15000 machine .
>
>Qs How may the following issue be approached .?
>Qs Of now we are Looking at truss Output taken from the 2 machines . Is
>this
>
>a suitable method ?
>Qs Any proven Kernel parameters which are SF15K specific ?
>Qs Will remake of Oracle Software on SF 15K help ?
>(Oracle S/w was installed on the Storage Box when it was connected to
>SF6800
>Qs Will Upgrade to 8.1.7.4 Help ?
>Qs Is Oracle 8.1.7.4 (32-bit version) on Solaris 8 Safe for Deployment ?
>
>
>Thanks
>
>Details below in Tar raised with Oracle Corp :-
>
>
>TAR Number 2499667.996 Open Date 23-OCT-02 07:20:04
>Support Identifier 4505100470 Name Infosys Info
>Priority 2 Last Update 23-OCT-02 01:27:27
>Product Oracle Server - Enterprise Edition Product Version 8.1.7.2
>Platform Solaris Operating System (SPARC) (64-bit) Detailed Status
>Modified via MetaLink
>TAR Reference n/a BUG Reference n/a
>
>Abstract
>
>High CPU Consumption after moving to SF15000 machine
>
>Resolution History
>
>
>23-OCT-02 07:20:04
>
>
>Can you easily recover from, bypass or work around the problem? = NO
>Does your system or application continue normally after the problem occurs?
>=
>NO
>Are the standard features of the system or application still available; is
>the
>loss of service minor? = YES
>
>### Operating System Configuration: ###
>32 bit Oracle software on 64 bit operating system
>
>### Error Messages: ###
>NO Error messages
>
>### Problem Description: ###
>Much Higher CPU Utilization Occuring after Moving to Sun Fire (SF) 15000
>machine (24 CPUs @ 900 MHz) from Sun Fire(SF) 6800 machine ( 24 CPUs @ 750
>MHz ) . CPU Utilization increased by 15 %.
>
>Hardware / OS INFO
>==================
>1) Database & Application Servers are Separate machines Both being SF15000
>&
>
>being SF6800s before changeover
>
>2) The Storage Box Containing Oracle Software & Database [ Hybrid Banking
>Application ]was simply UNPlugged from the SF 6800 machine & plugged to the
>SF 15000 machine . Storage Box Model = XP 512
>
>3) Database Exists on the Following File systems :-
>Veritas File system Version 3.4
>Veritas Volume Manager version 3.2
>
>4) Patch Info on Database Server :-
>uname -X
>System = SunOS
>Node = IB15KDB
>Release = 5.8
>KernelID = Generic_112953-02
>Machine = sun4u
>BusType = <unknown>
>Serial = <unknown>
>Users = <unknown>
>OEM# = 0
>Origin# = 1
>NumCPU = 24
>
>ORACLE INFO
>===========
>1) Oracle 8.1.7.2 with 3 Standalone 1 Off patches :-
>Patch for Backport #2038901 for base bug 1951929
>Patch for Backport #2165928 for base bug 2079526
>Patch for Backport #2144455 for base bugs 1567117, 1661786,
># 1663288, 1802230, 1836101, 1838517, 1874468, 1944351,
># 1951929 and 1967363
>) Much Higher Database Contention Also Observed after Switch-Over
>Database Contention BEFORE CHANGE (taken on SF6800)
>Snap Id Snap Time Sessions
>------- ------------------ --------
>Begin Snap: 15090 13-Sep-02 11:30:03 3,093
>End Snap: 15130 13-Sep-02 13:30:01 3,093
>Elapsed: 119.97 (mins)
>Top 5 Wait Events
>~~~~~~~~~~~~~~~~~ Wait % Total
>Event Waits Time (cs) Wt Time
>-------------------------------------------- ------------ ------------
>-------
>db file sequential read 51,789,298 10,303,197 77.35
>log file sync 569,163 1,285,175 9.65
>latch free 517,175 600,623 4.51
>db file parallel write 424,656 337,252 2.53
>db file scattered read 2,402,254 262,153 1.97
>-------------------------------------------------------------
>
>Following is the Database Contention AFTER CHANGE to SF15000 machine
>
>Snap Id Snap Time Sessions
>------- ------------------ --------
>Begin Snap: 15452 18-Sep-02 11:30:11 3,052
>End Snap: 15482 18-Sep-02 13:30:04 3,052
>Elapsed: 119.88 (mins)
>Top 5 Wait Events
>~~~~~~~~~~~~~~~~~ Wait % Total
>Event Waits Time (cs) Wt Time
>-------------------------------------------- ------------ ------------
>-------
>db file sequential read 61,529,813 21,742,993 77.05
>log file sync 534,929 3,598,646 12.75
>latch free 1,032,105 1,192,154 4.22
>db file parallel write 267,841 484,510 1.72
>db file scattered read 2,544,156 400,437 1.42
>-------------------------------------------------------------
>Do Let me know should you need any Other info
>
>### Oracle Real Application Cluster: ###
>Choose...
>
>### Version of Clustering software: ###
>Database Exists on the Following File systems :-
>Veritas File system Version 3.4
>Veritas Volume Manager version 3.2
>
>### Files to be uploaded: ###
>1) /etc/system File Attached
>2) mount info File Attached
>
>### List of PC X-Server version and vendor info: ###
>N/A
>
>### Error of Frequency: ###
>N/A
>
>### Installation Source: ###
>CD-ROM
>
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:25:09 EDT