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 <[EMAIL PROTECTED]> 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. > [EMAIL PROTECTED] > > > -----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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
