RE: Space Remaining in Current Extent

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 - Since you haven't received any replies, here goes.
Within an extent, Oracle uses blocks. I haven't seen a way to find the used
space within a block. There are methods to find the number of empty blocks
underneath the high water mark. Analyze does that, but you've ruled that
out. It might help if you could explain what you are trying to accomplish.
Other ideas are:

Write a program that will scan the table, read each row and count the
bytes as it reads it. This would be very accurate, but time-consuming.

An approximate answer could be arrived at by doing an analyze and
getting average row length. This shouldn't change much unless some operation
is performed that would alter that. Then by getting the number of rows in
the table you could get a very close estimate of the table size at any time.

Hey guys;
Does anyone know where I can look to find the space remaining in an
individual extent ?? I know that you can get the freespace from
dba_free_space but that seems to be based only on unallocated extents. I
have been asked to find out, down to the byte, how much free space is
available ..... on the fly (which means not only after every analyze)

Any suggestions ??? I am sure Oracle has a table with the information
somewhere .

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_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).
--

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_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).
--

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_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).
Received on Tue May 27 2003 - 15:09:44 CDT