02-07-12, 16:24 #1Registered User
- Join Date
- Sep 2011
Unanswered: Determining reusable blocks per table
Hi all, a question.
dba_segments and dba_free_space provides a convenient way to look at space that is owned by a table or object compared to the size of datafile.
However, I know that when a table deletes many rows, there is free space left within it. This space can be reused by the table itself. But to an outsider, it appears to take up the same amount of space in dba_segments, and dba_free_space. So a table may appear to be at 20mb size, but have a lot of reusable space within it, meaning it won't grow for a long time.
Is there a way for me to query how much reusable space a table has? I think these are called freelists.
02-07-12, 16:31 #2Registered User
Provided Answers: 1
- Join Date
- Aug 2003
- Where the Surf Meets the Turf @Del Mar, CA
>Is there a way for me to query how much reusable space a table has?
Yes, but nontrivial to do.
Besides what can & do you plan on doing with any such answer;
since you have *NO* control over where Oracle actually places data upon INSERT?You can lead some folks to knowledge, but you can not make them think.
The average person thinks he's above average!
For most folks, they don't know, what they don't know.
Good judgement comes from experience. Experience comes from bad judgement.