From oracle-l-bounce@freelists.org Thu Oct 20 13:05:51 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j9KI5nD7006188 for ; Thu, 20 Oct 2005 13:05:50 -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 j9KI5hvX006158 for ; Thu, 20 Oct 2005 13:05:44 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A857B209EDC; Thu, 20 Oct 2005 13:05:31 -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 09309-09; Thu, 20 Oct 2005 13:05:31 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D8A4C209FC9; Thu, 20 Oct 2005 13:05:30 -0500 (EST) From: "Pete Sharman" To: "rjamya@gmail.com" , "DGoulet@vicr.com" Cc: "ora_forum@yahoo.com" , "oracle-l@freelists.org" , "Peter Ross Sharman" Subject: RE: Extent allocation time Date: Fri, 21 Oct 2005 04:02:52 +1000 Message-ID: <20051021040252194.00000002116@psharman-au> In-Reply-To: <9177895d0510201055s4eed2b3ej564c7e4f86865ab1@mail.gmail.com> X-Accept-Language: en-au, en MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis X-Brightmail-Tracker: AAAAAQAAAAIX-Whitelist: TRUE X-archive-position: 27273 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: peter.sharman@oracle.com Precedence: normal Reply-To: peter.sharman@oracle.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.0 required=5.0 tests=AWL,BAYES_00 autolearn=ham version=2.63 Funny, I read this completely differently, as in I thought the original question meant "Is there a way I can stop an extent allocation failing because it ran out of space while I go and research where I can extend the tablespace to?" :) I guess your reading is more correct though when I go back and look at the question. If it is, then Steve of course was right. If it's not, and you ARE actually wanting the extent allocation to hang rather than fail immediately, then there is a way of doing that. It's called resumable space allocation. Search on tahiti to find more.   Pete   "Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook   "Oh no, it's not.  It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA ________________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of rjamya Sent: Friday, 21 October 2005 3:55 AM To: DGoulet@vicr.com Cc: ora_forum@yahoo.com; oracle-l@freelists.org Subject: Re: Extent allocation time Steve adams mentioned long time ago that is is way difficult to do. but if you are willing to dump archive logs with the right later and op code, you may be able to find it. you are running in archivelog mode right? Raj -- http://www.freelists.org/webpage/oracle-l