Oracle-L: RE: Over Consumption of CPU ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Tue, 15 Oct 2002 09:46:18 -0800
Message-ID: <F001.004E9877.20021015094618@fatcity.com>

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.

NOTE - The Storage Box Continues to be the SAME . It has simply moved from the previous SF6800 machine to SF15K machine .

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

-----Original Message-----
Sent: Tuesday, October 15, 2002 8:06 PM
To: VIVEK_SHARMA

Vivek,

Please clarify... a Sun Fire 6800 and a Sun Fire 15000 are not storage boxes - they are CPUS/RAM/interfaces to storage. What is the actual back end storage (EMC, Sun Storage, ?)

Steve

"VIVEK_SHARMA" <VIVEK_SHARMA_at_infosys.com> writes:

To: "LazyDBA.com Discussion" <oracledba_at_lazydba.com> Date: Tue, 15 Oct 2002 17:33:02 +0530

On Moving the Storage Box from a SF6800 machine to SF15000 machine CPU Consumption has Shot UP 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 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 ?

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: VIVEK_SHARMA
INET: VIVEK_SHARMA_at_infosys.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 15 2002 - 12:46:18 CDT