Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news-out.visi.com!petbe.visi.com!out.nntp.be!propagator2-sterling!in.nntp.be!newsfeed01.tsnz.net!ken-transit.news.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail From: "Richard Foote" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server References: <4329cc8c.0304260657.d37c66f@posting.google.com> Subject: Re: UNUSED SPACE IN TABLE Lines: 23 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2720.3000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: Date: Sun, 27 Apr 2003 19:41:29 +1000 NNTP-Posting-Host: 203.54.191.208 X-Trace: newsfeeds.bigpond.com 1051435609 203.54.191.208 (Sun, 27 Apr 2003 19:26:49 EST) NNTP-Posting-Date: Sun, 27 Apr 2003 19:26:49 EST Organization: Telstra BigPond Internet Services (http://www.bigpond.com) Xref: core-easynews comp.databases.oracle.misc:97046 comp.databases.oracle.server:184559 X-Received-Date: Sun, 27 Apr 2003 02:39:44 MST (news.easynews.com) "GAURAV MITTAL" wrote in message news:4329cc8c.0304260657.d37c66f@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