Re: HELP! Oracle are eating my bytes!

From: Sanjeev.Agrawal <sanju_at_churchill.ColumbiaSC.NCR.COM>
Date: Tue, 12 Oct 1993 18:00:54 GMT
Message-ID: <CEsq1I.6vv_at_ncrcae.ColumbiaSC.NCR.COM>

In article <1993Oct11.200808.123_at_debet.nhh.no> edb_gunder_at_debet.nhh.no writes:
>I have the following problem with Oracle7: Oracle reports the tablespace
>where SYSTEM resides to be nearly full. So I can not create any more
>tables etc. But I have justed added a 40 MB datafile to the tablespace
>because it behaved the same way before. Before the tablespace was 20 MB.
>I have look at the tables and nearly all of them are empty. So my
>question is where has the space gone? Is there a way to see how much a
>table is using of bytes in a tablespace?
>
>I can not figure this out, and hope for "a little help of my friends".

Just give it a try !

Script follows:

#####################################################################

clear computes
clear breaks
set pagesize 66
break on report
compute sum of a on report
column a format 999.99 heading "Size in MB" spool tab_db_size
select substr(segment_name,1,15) Object, substr(segment_type,1,5) Type,bytes, blocks,extents, round((blocks/512),2) a
from user_segments
order by blocks
/
spool off
clear computes
clear breaks

########################################################

You may like to play around dba_free_space and user_free_space objects.

Luck !

Sanjeev
>
>Thanks!
>
>Gunder

-- 
*-------------------------------------------------------------------------*
|  Sanjeev Kumar Agrawal          Phone: (803) 791-6516(W) / 798-2799 (H) |
|                   Think there is a Better Way to Do It !                |
*-------------------------------------------------------------------------*

Received on Tue Oct 12 1993 - 19:00:54 CET