dbms_space.unused_space will give you the total blocks allocated and
the unused blocks. You get "of 300 blocks allocated, unused blocks=45".
It won't give you "of used block 10, there are 300 bytes free" but I
don't know of anything that does that.
- Kevin Lange <klange_at_ppoone.com> 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.
>
> -----Original Message-----
> Sent: Tuesday, May 27, 2003 2:40 PM
> To: Multiple recipients of list ORACLE-L
>
>
> 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.
>
> Dennis Williams
> DBA, 80%OCP, 100% DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
>
>
> -----Original Message-----
> Sent: Tuesday, May 27, 2003 11:15 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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 .
>
> Thanks
>
> Kevin
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kevin Lange
> INET: klange_at_ppoone.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_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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: DENNIS WILLIAMS
> INET: DWILLIAMS_at_LIFETOUCH.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_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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Kevin Lange
> INET: klange_at_ppoone.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_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).
>
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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_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 - 16:24:40 CDT
