From oracle-l-bounce@freelists.org Thu May 19 11:50:44 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j4JGoiAQ018545 for ; Thu, 19 May 2005 11:50:44 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j4JGoi4Z018540 for ; Thu, 19 May 2005 11:50:44 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 72D1B19560C; Thu, 19 May 2005 10:47:53 -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 27044-08; Thu, 19 May 2005 10:47:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F3371195687; Thu, 19 May 2005 10:47:52 -0500 (EST) Message-Id: Date: Thu, 19 May 2005 11:45:35 -0400 From: "Jeffrey Beckstrom" To: , , , , Subject: Limit sort space used by Discoverer Mime-Version: 1.0 Content-type: text/plain Content-Transfer-Encoding: 8bit X-archive-position: 19933 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: JBECKSTROM@gcrta.org Precedence: normal Reply-To: JBECKSTROM@gcrta.org X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: ** X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=2.1 required=5.0 tests=AWL,SUSPICIOUS_RECIPS autolearn=no version=2.63 We are using a dictionary managed tablespace for sorts so that we can limit the maximum space grabbed by a sort to 1 G. I know it is not possible after the fact to determine who took all of the sort space, however, we believe it is Discoverer. We are reluctant to convert to a temporary tablespace since there is no way to limit sort space with them. This is an ERP system and we don't want Discoverer grabbing all of the space and killing payroll, etc. Can Discoverer be limited in some way? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 -- http://www.freelists.org/webpage/oracle-l