Higher CPU Utilization on SF15K m/cs

From: vivek sharma (vivek_sharma_1@hotmail.com)
Date: Wed Oct 23 2002 - 05:11:18 EDT


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



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:25:09 EDT