Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Posts
    77

    Unanswered: Free blocks below HWM

    Hi guys,

    I have analyzed my table, Do you guys have a query that I could use to find the empty blocks below the High water mark thanks

  2. #2
    Join Date
    Apr 2001
    Location
    Netherlands
    Posts
    191
    The number of empty blocks is not very hard...
    (empty blocks - (table size -hwm)*blocksize)

    But if you wanna know the excact blocks, I don't know.
    Ruud Schilders
    -----------------
    Oracle DBA
    e-mail : ruud@schilders.it
    URL : www.schilders.it
    Twitter : www.twitter.com/ruudschilders

Posting Permissions

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