Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Some basic dba_free_space stuff

Some basic dba_free_space stuff

From: Doug Cowles <dcowles_at_bigfoot.com>
Date: Wed, 02 Jun 1999 18:01:30 -0400
Message-ID: <3755A9BA.9B9F4685@bigfoot.com>


Just some basic questions about dba_free_space. I have a tablespace, which in dba_free_space shows some "chunks" of free space.
I'm wondering about the size of the chunks. If I delete a row for example, That one
small chunk of space surely isn't freed - so how does Oracle decide that a "chunk"
of space is free, after a certain number of deletes, does it do it's own coalescing
for example? There's a 400K block of space in the below output for example.
How did a "chunk" that size get freed?

Output is

tablespace             file_id             block_id
bytes              blocks
INTFD2                  15                    27
14540800          1775
INTFD2                  15                8267
409600              50
INTFD2                  15                8537         34930688
4264
INTFD2                  15                4187
7372800            900



Received on Wed Jun 02 1999 - 17:01:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US