Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h4S00gK04001 for ; Tue, 27 May 2003 19:00:42 -0500 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h4S00e103995 for ; Tue, 27 May 2003 19:00:40 -0500 Received: from fatcity.com (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id OAA52185; Tue, 27 May 2003 14:29:02 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 005A3A32; Tue, 27 May 2003 13:54:41 -0800 Message-ID: Date: Tue, 27 May 2003 13:54:41 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: Stephane Faroult Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: Stephane Faroult Subject: Re: Space Remaining in Current Extent Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Kevin Lange wrote: > > As to what this is for ..... > > I have a request to come up with a way to guage space remaining on an on > going basis .... i.e. If I look at the space available between 2 > different user transactions I will see a difference. Most of the methods I > have seen so far either rely on Analyze or show simply the amount of space > that has been allocated to the table at this time (not the actual "This is > what you have allocated" and "This is what you have free"). > > I have tried using dbms_space but it again shows (at least I interpret it > that way) the amount of space allocated , not neccessarily exactly what is > in use. > > If there is an obvious v$ or x$ view out there someplace where I can get > this info, it would be great. > Kevin, First understand that this is not directed to you but to your damagement - I have seen the "request" :-). Why do you want a real-time, down-to-the-latest-byte result? This is absolutely idiotic. Whenever you want to order something with the likes of EMC, the smallest unit available will be in the order of magnitude of the Terabyte. I understand your management probably had most of their real-life IT experience on a 640K, dual 5 1/4 diskettes, no hard disk (pre-XT, ca 1985). Use 'round()' to the nearest Gb, it will smoothen the differences. HTH S Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: sfaroult@oriole.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).