From: VIVEK_SHARMA (VIVEK_SHARMA@infosys.com)
Date: Tue Oct 15 2002 - 13:35:52 EDT
NOTE - The Storage Box Continues to be the SAME .
It has simply moved (UNPlugged ) from the previous SF6800 machine & Plugged
(Attached) to the SF15K machine.
The back end storage box is :-
HP Storage Box Model = XP512
1 Volume only (RAID 5) exists across ALL the underlying Disks
Total Number of Underlying Disks = 56
Veritas File System (VXFS) partitions Sit above the Volume (RAID 5)
Thus the hardware is a Hybrid Setup combining a SUN Machine with a HP Storage
ORACLE_HOME , Database Both Exist on the Storage Box.
The CPU Utilizations of BOTH APP & DB Server machines has Shot UP by 25 % .
Both APP & DB Server machines have identical configuration i.e. SF15K machines
,
while previously Both used to be SF6800 machines
Thanks indeed
P.S. Interpretations can be so different in English
-----Original Message-----
From: Martin Hepworth [mailto:martinh@solid-state-logic.com]
Sent: Tuesday, October 15, 2002 5:50 PM
To: VIVEK_SHARMA
Subject: Re: Over Consumption of CPU ?
Vivek
What's Oracle up to on this new box. Have you looked at the tuning
options in Oracle, and particularly the tracing stuff to see what's
happening? (ie sql_trace and tkprof).
It could be that you've got fragmented tables or indexes which is
slowing the whole thing up, or even forgot to recreate an index when you
moved the DB across.
-- Martin Hepworth Senior Systems Administrator Solid State Logic Ltd +44 (0)1865 842300 VIVEK_SHARMA wrote: > On Moving the Storage Box from a SF6800 machine to SF15000 machine CPU > Consumption has Shot > by 25 % > > Particulars :- > Number of CPUs on SF6800 = 24 with 750 MHz Clock Speed > Number of CPUs on SF15000 = 24 with 900 MHz Clock Speed > > Both %usr & %sys CPU Utilization components seem to have gone up > > Solaris 8 > Oracle 8.1.7.2 (+ Some Stand-Alone 1 Off patches) > Database Size 500 GB > Nature of Application Database = Hybrid (Banking application) > Number of Concurrent User processes = 2500 > > Qs How may the Following problem be approached towards resolution ? > Qs Is using truss Command to identify the Cause a Good approach ? > Qs Are there any parameters / Switches which may given with the truss Command > to get the % CPU consumed by the underlying system Calls ? > Qs Are there any preferred parameters Specific to SF15000 ? _______________________________________________ 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:07 EDT