From oracle-l-bounce@freelists.org Fri Apr 30 23:46:51 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i414ka617522 for ; Fri, 30 Apr 2004 23:46:46 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i414kQ617509 for ; Fri, 30 Apr 2004 23:46:36 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 07C2072CD55; Fri, 30 Apr 2004 23:38:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 29640-13; Fri, 30 Apr 2004 23:38:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A8ABD72CB05; Fri, 30 Apr 2004 23:37:59 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 30 Apr 2004 23:36:44 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7FAE172CABE for ; Fri, 30 Apr 2004 23:36:44 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27570-83 for ; Fri, 30 Apr 2004 23:36:44 -0500 (EST) Received: from www.hotsos.com (hotsos.com [209.120.206.15]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0180B72C9FE for ; Fri, 30 Apr 2004 23:36:44 -0500 (EST) Received: from CVMLAP02 (66.169.163.33.ts46v-12.otne2.ftwrth.tx.charter.com [66.169.163.33]) (authenticated (0 bits)) by www.hotsos.com (8.12.11/8.11.0) with ESMTP id i414nn56020007 for ; Fri, 30 Apr 2004 23:49:50 -0500 From: "Cary Millsap" To: Subject: RE: CPU upgrade caused application slow down Date: Fri, 30 Apr 2004 11:49:42 -0500 Message-ID: <000801c42ed3$26664430$6901a8c0@CVMLAP02> MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.3416 In-Reply-To: <00a201c42f2f$fa9873c0$2552fc0a@corp.ebay.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Importance: Normal X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4156 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: cary.millsap@hotsos.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Zhu, The condition that will cause response time to get /worse/ is if your CPU upgrade speeds up some number of competing processes, allowing them to compete more vigorously (that is, same number of calls in a smaller time window) for the resource that was already responsible for a lot of your more-important application's response time before the upgrade. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 5/7 Dallas, 5/18 New Jersey, 6/22 Pittsburgh - SQL Optimization 101: 5/3 Boston, 5/24 San Diego, 6/14 Chicago - Hotsos Symposium 2005: March 6-10 Dallas - Visit www.hotsos.com for schedule details... -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of zhu chao Sent: Friday, April 30, 2004 10:54 PM To: oracle-l@freelists.org Subject: Re: CPU upgrade caused application slow down Hi, Waleed: That is what I do everytime I reorgnized a table. The table that got reorgnized was an IOT table with Overflow segment. After table recreated, I move overflow segment to make it sorted. One more thing, the table is not a key table of the applications running on this server, thoug the table is pretty big in size. I guess the difference in response time is from the network layer.But I cannot prove it. No improvement in response is ok for CPU upgrade, as CPU time is just part of the total response time, but it should not get longer:(, right? Thanks Zhu Chao ----- Original Message ----- From: "Khedr, Waleed" To: Sent: Saturday, May 01, 2004 11:26 AM Subject: RE: CPU upgrade caused application slow down > Wondering if you have one major index that gets used most of the time = > using range scan. > If this is true, then reorganizing the table might have damaged a little = > bit the clustering factor. > > If this is the case, then loading the table sorted on the columns used = > by that index should help a lot. > > Regards, > > Waleed ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------