Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Space Utilization Problems
Stuart,
If you analyze the table dba_tables will show you the number of blocks used and the empty blocks. You can use exec dbms_utility.analyze_schema('schemaname','ESTIMATE'); to analyze all the tables in a schema.
-Kim Received on Tue Jun 02 1998 - 11:37:21 CDT