Oracle-L: RE: Over Consumption of CPU ?

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Tue, 15 Oct 2002 10:50:02 -0800
Message-ID: <F001.004E9A4A.20021015105002@fatcity.com>

Solaris 8 always Existed on Internal Disks on Both SF15K & SF6800 machines

Patch Levels same on Both SF15K & SF6800 (though I will RE-Check it)

Oracle Binaries NOT recompiled after moving the Storage Box . Would you advise it ?

Thanks

-----Original Message-----
Sent: Tuesday, October 15, 2002 10:38 PM To: VIVEK_SHARMA

I am wondering: is Solaris on the XP512 as well or is it on internal storage on the SF15000?

If it is on the SF15000 itself, are the patch levels the same as what was on the SF6800? and did you recompile the Oracle binaries?

Steve

"VIVEK_SHARMA" <VIVEK_SHARMA_at_infosys.com> writes:

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

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 - 13:50:02 CDT