Re: UNUSED SPACE IN TABLE

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Sun, 27 Apr 2003 19:41:29 +1000
Message-ID: <tnNqa.23312$1s1.356845@newsfeeds.bigpond.com>

"GAURAV MITTAL" <gaurav82online_at_yahoo.com> wrote in message news:4329cc8c.0304260657.d37c66f_at_posting.google.com...
> how do i find the unused space in a table.actually my table contained
> 7.8 million records.i deleted 4 million records.the count(*) on the
> table shows 3.8 million records.However when i queried the num_rows in
> dba_tables it showed 7.8 million rows.
> also the space occupied before delete was fired showed 50
> gigs in the bytes column in dba_tables and the same was showed in the
> dba_tables(bytes column) after the delete was done.
>
> does anybody have anwser??

Hi Gaurav,

Hummm, try and re-"analyze" the table and see what the current statistics might be. The stats stored in dba_tables (etc.) are not dynamic and need to be manually refreshed (analyze command, dbms_stats package, etc.)

Cheers

Richard Received on Sun Apr 27 2003 - 04:41:29 CDT