Hello all, DB: 8i OS: soalris 2.8
why DBMS_SPACE.FREE_BLOCKS is not giving correct status: create table ram1 (a number); analyze table ram1 compute statistics; select table_name, blocks,empty_blocks from dba_tables where table_name = 'RAM1'; TABLE_NAME BLOCKS EMPTY_BLOCKS RAM1 0 4 Using dbms_space.free_space: set serveroutput on declare free number; begin dbms_space.free_blocks('SYS','RAM1','TABLE',0,free); dbms_output.put_line('Free blocks '||free); end; / > Free blocks 0 > > PL/SQL procedure successfully completed. am I missing something ? regards, srinivas __________________________________________________ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: kommareddy sreenivasa INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).