From oracle-l-bounce@freelists.org Tue Mar 30 16:24:08 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2UMO8928593 for ; Tue, 30 Mar 2004 16:24:08 -0600 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 i2UMO8o28588 for ; Tue, 30 Mar 2004 16:24:08 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 23A7C634416; Tue, 30 Mar 2004 17:20:43 -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 29147-78; Tue, 30 Mar 2004 17:20:42 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5A77363442B; Tue, 30 Mar 2004 17:20:42 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 30 Mar 2004 17:19:34 -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 24A0B634104 for ; Tue, 30 Mar 2004 17:19:34 -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 29147-58 for ; Tue, 30 Mar 2004 17:19:33 -0500 (EST) Received: from relay01.uchicago.edu (relay01.uchicago.edu [128.135.12.136]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A4F046340BB for ; Tue, 30 Mar 2004 17:19:33 -0500 (EST) Received: from AIS-PC2.uchicago.edu (ais-pc2.uchicago.edu [128.135.15.112]) by relay01.uchicago.edu (8.12.10/8.12.9) with ESMTP id i2UMRhLA011080 for ; Tue, 30 Mar 2004 16:27:43 -0600 (CST) Message-Id: <5.2.0.9.2.20040330160102.0275b988@nsit-imap.uchicago.edu> X-Sender: mschmitt@nsit-imap.uchicago.edu X-Mailer: QUALCOMM Windows Eudora Version 5.2.0.9 Date: Tue, 30 Mar 2004 16:27:43 -0600 To: oracle-l@freelists.org From: Mike Schmitt Subject: RE: Database sloowww...trying to figure out why... In-Reply-To: <4A82CFCF30FDD211A7960008C7B1917023696973@hero.affina.net> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=====================_-1254147234==.ALT" X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 2125 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: mschmitt@uchicago.edu Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org --=====================_-1254147234==.ALT Content-Type: text/plain; charset="us-ascii"; format=flowed As someone else mentioned, I think you might need to spend a little more time collecting the right data and then start fixing your problems by priority. I am guessing that all of your users are complaining about performance at this point. Something that I have noticed in the past when working on Oracle apps installations is that poorly custom coded reports, jobs, and forms can really tear away at the performance as they slowly get introduced. You should be able to find out which jobs are the most critical and taking the longest to run within apps. Start tracing those jobs as they run and working on improving their performance. In other words, improving the puzzle piece by piece can often improve the whole. Also, watch out for forms that allow the users to run selects without providing fields to select by. These can easily chew up a lot of resources. Anyways, Im sure people on here will be able to give you better advice Good luck : ) >....much of the problem lies in custom scripting not in a particular module.. --=====================_-1254147234==.ALT Content-Type: text/html; charset="us-ascii"

As someone else mentioned, I think you might need to spend a little more time collecting the right data and then start fixing your problems by priority.  I am guessing that all of your users are complaining about performance at this point. 

Something that I have noticed in the past when working on Oracle apps installations is that poorly custom coded reports, jobs, and forms can really tear away at the performance as they slowly get introduced.  You should be able to find out which jobs are the most critical and taking the longest to run within apps.  Start tracing those jobs as they run and working on improving their performance.  In other words, improving the puzzle piece by piece can often improve the whole.  

Also, watch out for forms that allow the users to run selects without providing fields to select by.  These can easily chew up a lot of resources. 

Anyways,  Im sure people on here will be able to give you better advice

Good luck : )  




....much of the problem lies in custom scripting not in a particular module..

--=====================_-1254147234==.ALT-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------