Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> CPU upgrade caused application slow down

CPU upgrade caused application slow down

From: zhu chao <chao_ping_at_vip.163.com>
Date: Fri, 30 Apr 2004 17:41:40 +0800
Message-ID: <001401c42e97$58e35790$2552fc0a@corp.ebay.com>


Hi, list friends:     

    We did a server upgrade this month. And we hit something we cannot understand. So we refer to you guys for help , hoping you have similar experienceJ

            We did a server upgrade this month. Biddb upgrade from 8*900MHZ FireV880 to 8*1200MHZ Fire V880, SAN HBA card also upgraded from 1gb to 2gb.

             System Level parameter like /etc/system, oracle initsid.ora are same for biddb before and after server upgrade.(except for processes increased from 800 to 1200).SGA of database is reduced from 11.5GB to 11GB.But disk read did not increase as we reorganized a table with 29M records to 13M records(CTAS, drop old table).

                       The upgrade result is good,  CPU usage dropped about 20%-30% percent.  But the application response time does not drop. It even slow down slightly. :(.  This is not what we expect. Statspack  does not show much difference before and after upgrade(load profile , wait event etc).

            Later we did some test, hoping to find out how can this happen, but we cannot draw a conclusion from our test result.


  1.. According to Cary Millsapí»s theory, upgrade CPU *CAN* make performance worse. In his case, SQL*Net was the bottleneck. Our server network traffic is only at 15-20Mb/Second. This seems not like the bottleneck, Though from 10046 trace report, sqlnet wait is the NO.1 wait event, but this is normal for most applications. I also tried to change the tnsnames.ora and listener.ora with larger SDU/TDU of 8KB, restarted tuxedo service and oracle listener. And compare the performance data leter. This does not make much difference for application response time.

  2.. We did some pure simple SQL test. Result in appendix 1. SAME SQL in 1200MHZ CPU does run faster.  

  2.. We write a simple tuxedo service run the same SQL for 1000 times. Everytime the SQL is transferred through SQL*Net and result is fetched into host variable. The result still shows that it runs faster on 1200MHZ CPU. The average response time in 1200MHZ server is 12.12ms ,and the average response time in 900mhz server is 14.20ms.  

We cannot find out the root cause of application slow down. Though the slow down is very small (around 5% percent, maybe), it is not happy to see such result and we are interested in knowing why.

If you have similar experience before and do find out how this can happen, we would be very happy.  

Thanks for your time.

Regards

Zhu Chao.      

Appendix 1:

Eachdb2: (900mhz CPU)  

  1 declare v_result number;

  2 begin

  3 for x in 1..1000 loop

  4 select count(*) into v_result from testsystem;

  5 end loop;

  6* end;

09:38:13 7 /  

PL/SQL procedure successfully completed.  

Elapsed: 00:02:17.37

09:40:31 SQL>   Biddb (1200MHZ CPU)  

  1 declare v_result number;

  2 begin

  3 for x in 1..1000 loop

  4 select count(*) into v_result from testsystem;

  5 end loop;

  6* end;

09:42:29 SQL> 09:42:30 SQL> 09:42:30 SQL> /   PL/SQL procedure successfully completed.

Elapsed: 00:01:57.99



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

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
Received on Fri Apr 30 2004 - 04:38:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US