Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Over Consumption of CPU ?

RE: Over Consumption of CPU ?

Date: Tue, 15 Oct 2002 10:36:52 -0800
Message-ID: <>

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-----
Sent: Tuesday, October 15, 2002 5:50 PM


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


> 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 (+ 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 ?
-- Please see the official ORACLE-L FAQ: -- Author: VIVEK_SHARMA INET: Fat City Network Services -- 858-538-5051 San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: (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:36:52 CDT

Original text of this message