RE: Over Consumption of CPU ?

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
To: VIVEK_SHARMA

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 ?

>

-- 
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).