From: vivek sharma (vivek_sharma_1@hotmail.com)
Date: Thu Oct 24 2002 - 14:02:04 EDT
Run a Batch Process as follows & truss -aefc Output taken during the
Run (from Begin to End)
CASE 1
Run the Process from machine SF6800 (APP Server) taken under NO Load with 24
CPUs ( @ 750 MHz ) before Relinking Oracle 8.1.7.2
"llseek" time of sys call , in secs = .39
CASE 2
Run the Same Process from machine SF15000 (APP Server) under NO LOAD
Conditions with 24 CPUs only enabled ( 900 MHz ) before Relinking Oracle
8.1.7.2
"llseek" time of sys call , in secs = 1.17
CASE 3
Run the Same Process from machine SF15000 (APP Server) under NO LOAD
Conditions with 24 CPUs only enabled ( 900 MHz ) after Relinking Oracle
8.1.7.2
"llseek" time of sys call , in secs = 1.04
Thus "llseek" sys Call Timing is consistently much Higher on SF15K versus
SF6800
NOTE
1) Total Elapsed can NOT be Considered because When doing the Runs WITHOUT
the truss Option the Timing on SF15K is LESS Than on SF6800
2) DB Server is a 4 CPUs SUN450 Box containing a Common Test Database which
has NO Other Load .
I will provide any data required
Thanks
>
>-----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
>
>
>
>_________________________________________________________________
>Unlimited Internet access -- and 2 months free! Try MSN.
>http://resourcecenter.msn.com/access/plans/2monthsfree.asp
>_______________________________________________
>sunmanagers mailing list
>sunmanagers@sunmanagers.org
>http://www.sunmanagers.org/mailman/listinfo/sunmanagers
_________________________________________________________________
Broadband? Dial-up? Get reliable MSN Internet Access.
http://resourcecenter.msn.com/access/plans/default.asp
_______________________________________________
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