Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> freelists and dba_free_space
we are running Oracle 9.2.0.5 and I am fairly new at this DBA stuff. I
need some clarification on space management.
We just purged 2.5 million records from a table this weekend, and I can't seem to find that free space reflected anywhere. I guess I could see that possibly enough records from any one block were not removed to drop the blocks below pctused, I just don't think that is the case though. The data that was purged was data from 4 years ago, I would think it would have been located closely enough on the datafiles that quite a few blocks would have been freed.
Thanks for any info,
Ben
Received on Mon Feb 13 2006 - 15:41:22 CST