This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Jun 19, 2013 10:09 PM by Dizwell Go to original post RSS
  • 15. Re: Issue in understanding the negative Wasted space value for a table while fragmentation
    Dizwell Newbie
    Currently Being Moderated

    First, I apologise for the late response, and second for getting my maths completely backwards. I was tackling the inaccuracy of one half of your 'wasted' equation -and, in fact, completely the *wrong* half!

     

    Had I not had an altercation with a piece of public transport, my next response was to investigate all the reasons why what Oracle reports as allocated to a table might not be found in the table's own blocks... but I see Jonathan has beaten me to the punch.

     

    Thanks Jonathan: Iit would have taken me much longer to think of LOBs as a potential cause, anyway. (I was going to start by asking if the table was a cluster...)

1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points