Free space below HWM

From: Aldi Barco <ipal_at_hotmail.com>
Date: Mon, 24 Jul 2000 22:26:25 JAVT
Message-Id: <10568.112759@fatcity.com>

Hi list,

Because of delete operations, some tables in my database has a lot of free space below High Water Mark. For example for a table, HWM is 400 MB but the number of record is just about 2000. I try Select count(*), it takes time too long.
How to know how much is unused space below high water mark ? (for a table and index as well, because I want to know which index that has been candidate for rebuild).

Thank you.

Aldi
Oracle DBA

---

Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com Received on Wed Dec 31 1969 - 17:59:59 CST