Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2011
    Posts
    5

    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.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •