From: vivek sharma (vivek_sharma_1@hotmail.com)
Date: Thu Oct 24 2002 - 14:13:17 EDT
Run the Same Batch Process Option
Detailed truss -aefdD Outputs taken during the Run (from Begin to End) .
CASE 1
======
Run the Option from machine SF6800 (APP Server) taken under NO Load with 24
CPUs ( @ 750 MHz ) before Relinking Oracle 8.1.7.2
Pasting ALL system Calls Greater than 2 seconds Descending (3rd Column
below):-
NOTE - Line Length being Long , a wrap-around of data is occuring below
21720: 16.6276 7.9115 vfork() (returning as child ...) = 21648
21746: 17.6519 7.8143 vfork() (returning as child ...) = 21654
21461: 27.6347 7.3477 waitid(P_PID, 21835, 0xFFBECF28, 0403 )= 0
21835: 27.6320 7.3073 waitid(P_PID, 21837, 0xFFBEE970,
WEXITED|WTRAPPED|WNOWAIT) = 0
21694: 14.5838 6.9678 vfork() (returning as child ...) = 21642
21837: 27.2313 6.8675 waitid(P_PID, 21839, 0xFFBEE978,
WEXITED|WTRAPPED|WNOWAIT) = 0
21835: 20.2827 6.6508 vfork() (returning as child ...) = 21461
21831: 20.0492 6.4173 vfork() (returning as child ...) = 21461
21827: 19.9710 6.3391 vfork() (returning as child ...) = 21461
21823: 19.8985 6.2666 vfork() (returning as child ...) = 21461
21819: 19.8202 6.1883 vfork() (returning as child ...) = 21461
21815: 19.7330 6.1011 vfork() (returning as child ...) = 21461
21810: 19.6644 6.0325 vfork() (returning as child ...) = 21461
21806: 19.5853 5.9534 vfork() (returning as child ...) = 21461
21802: 19.4848 5.8529 vfork() (returning as child ...) = 21461
21798: 19.4145 5.7826 vfork() (returning as child ...) = 21461
21661: 12.2315 5.7168 vfork() (returning as child ...) = 21610
21772: 18.9737 5.3428 vfork() (returning as child ...) = 21688
21461: 13.6102 3.7912 lwp_sema_wait(0xFE70DE30)
Err#4 EINTR
21461: 13.6102 3.7911 lwp_cond_wait(0xFF2B5550, 0xFF2B5560, 0xFF2AEDB8)
Err#4 EINTR
21461: 13.6102 3.7805 lwp_cond_wait(0xFF2B5550, 0xFF2B5560, 0xFF2AEDB8)
Err#4 EINTR
21461: 12.5973 2.7056 wait() = 21610 [0x0000]
21461: 16.9805 2.0308 wait() = 21648 [0x0000]
CASE 2
======
Run the Option from machine SF15000 (APP Server) under NO LOAD Conditions
with 24 CPUs only enabled ( 900 MHz ) before Relinking Oracle 8.1.7.2
Pasting ALL system Calls Greater than 2 seconds Descending (3rd Column
below):-
27322: 29.6881 8.4148 waitid(P_PID, 27682, 0xFFBECB90, 0403 ) = 0
27682: 29.6849 8.3669 waitid(P_PID, 27684, 0xFFBEE5D8,
WEXITED|WTRAPPED|WNOWAIT) = 0
27684: 29.2042 7.8363 waitid(P_PID, 27686, 0xFFBEE5E0,
WEXITED|WTRAPPED|WNOWAIT) = 0
27322: 14.1866 4.0655 lwp_cond_wait(0xFF2B5550, 0xFF2B5560, 0xFF2AEDB8)
Err#4 EINTR
27322: 13.1773 2.9229 wait() = 27436 [0x0000]
27322: 18.5479 2.4475 wait() = 27494 [0x0000]
CASE 3
======
Run the Option from machine SF15000 (APP Server) under NO LOAD Conditions
with 24 CPUs only enabled ( 900 MHz ) after Relinking Oracle 8.1.7.2
Pasting ALL system Calls Greater than 2 seconds Descending (3rd Column
below):-
29769: 28.8384 8.0664 waitid(P_PID, 134, 0xFFBECB90, 0403 ) = 0
134: 28.8351 8.0165 waitid(P_PID, 136, 0xFFBEE5D8,
EXITED|WTRAPPED|WNOWAIT) = 0
136: 28.3683 7.4993 waitid(P_PID, 138, 0xFFBEE5E0,
WEXITED|WTRAPPED|WNOWAIT) = 0
29769: 13.8064 3.7487 lwp_cond_wait(0xFF2B5550, 0xFF2B5560, 0xFF2AEDB8)
Err#4 EINTR
29769: 13.8065 3.7334 lwp_cond_wait(0xFF2B5550, 0xFF2B5560, 0xFF2AEDB8)
Err#4 EINTR
29769: 12.7996 2.6360 wait() =
29898 [0x0000]
29769: 18.1454 2.4915 wait() =
29936 [0x0000]
NOTE
1) Total Elapsed time 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 .
>
>-----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