Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Space Remaining in Current Extent

Re: Space Remaining in Current Extent

From: Stephane Faroult <>
Date: Tue, 27 May 2003 13:54:41 -0800
Message-ID: <>

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.


  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:
Author: Stephane Faroult

Fat City Network Services    -- 858-538-5051
San Diego, California        -- Mailing list and web hosting services
To REMOVE yourself from this mailing list, send an E-Mail message
to: (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).
Received on Tue May 27 2003 - 16:54:41 CDT

Original text of this message