From oracle-l-bounce@freelists.org Mon Apr 26 14:41:14 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i3QJenY09285 for ; Mon, 26 Apr 2004 14:40:59 -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 i3QJed609244 for ; Mon, 26 Apr 2004 14:40:49 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4547C72D6EE; Mon, 26 Apr 2004 14:24: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 32347-20; Mon, 26 Apr 2004 14:24:44 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 22A8672D372; Mon, 26 Apr 2004 14:24:41 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 26 Apr 2004 14:23:25 -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 C9CC772D3EC for ; Mon, 26 Apr 2004 14:23:24 -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 29465-95 for ; Mon, 26 Apr 2004 14:23:24 -0500 (EST) Received: from corporate.LifeTouch.com (corporate.LifeTouch.com [63.71.63.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id CC5C372D456 for ; Mon, 26 Apr 2004 14:23:13 -0500 (EST) Received: from no.name.available by corporate.LifeTouch.com via smtpd (for freelists-180.iquest.net [206.53.239.180]) with SMTP; 26 Apr 2004 19:36:35 UT Received: (private information removed) Message-ID: <0186754BC82DD511B5C600B0D0AAC4D607B004FC@EXCHMN3> From: DENNIS WILLIAMS To: "'oracle-l@freelists.org'" Subject: RE: Performance PROBLEM Date: Mon, 26 Apr 2004 14:34:26 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2657.72) Content-type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 3796 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DWILLIAMS@LIFETOUCH.COM Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Seema I think you first need to establish why the application is running slow. Only after you understand why the application is slow can you map a strategy for improving the performance. You could run a 10046 trace as described in Cary Millsap's book. You could examine the v$ tables. You could run a STATSPACK report. Have you ever done any of these methods? Dennis Williams DBA Lifetouch, Inc. dwilliams@lifetouch.com -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org]On Behalf Of Seema Singh Sent: Monday, April 26, 2004 2:28 PM To: oracle-l@freelists.org Subject: Performance PROBLEM Hi, We are experiencing performance issues with one Sun database box. Oracle version=8.1.7.0 ,Memory=1.5gb SGA size=270mb, Database size 5MB. One of application is looking slow.This is third party application.We don't authorised to tune their query.Only We can do create indexes,cahe couple of tables,pin procedure etc. Can someone please suggest what can do other create indexes,cahe couple of tables,pin procedure in that schema.Any suggestions are welcome. Thanks -Seema _________________________________________________________________ FREE pop-up blocking with the new MSN Toolbar - get it now! http://toolbar.msn.com/go/onm00200415ave/direct/01/ ---------------------------------------------------------------- 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 -----------------------------------------------------------------