zzeuss
08 de Junio del 2006

Alguien sabe algun scrip para ver el espacio que ocupa un usuario de un tablespace

Rodolfo Reyes
08 de Junio del 2006

SELECT Total.name "Tablespace Name",
nvl(Free_space, 0) Free_space,
nvl(total_space-Free_space, 0) Used_space,
total_space
FROM
(select tablespace_name, sum(bytes/1024/1024) Free_Space
from sys.dba_free_space
group by tablespace_name
) Free,
(select b.name, sum(bytes/1024/1024) TOTAL_SPACE
from sys.v_$datafile a, sys.v_$tablespace B
where a.ts# = b.ts#
group by b.name
) Total
WHERE Free.Tablespace_name(+) = Total.name
ORDER BY Total.name

andrewsreid
08 de Junio del 2006

SQL> l
1 select tablespace_name, owner, sum(bytes)
2 from dba_segments
3 group by tablespace_name, owner
4* order by 1,2
SQL> /

TABLESPACE_NAME OWNER SUM(BYTES)
------------------------------ ------------------------------ ----------
AQ_READS DT 100352000
ASPE_DATA ASPE 29736960
BAF_DATA BAF 18882560
BAF_IND BAF 5324800
BANTOSCM_DATA BANTOSCM 26230784
BO_INDEX BUSOBJECTS 4374528
BRAID_DATA_LARGE BRAID 1074790400
BRAID_DATA_MEDIUM BRAID 199229440
BRAID_DATA_SMALL BRAID 46268416
BRAID_INDEX_LARGE BRAID 803209216
BRAID_INDEX_MEDIUM BRAID 180355072
BRAID_INDEX_SMALL BRAID 178388992
CRSLIV_DATA CRSLIV 532480
DATALOG_DATA DATALOG 120586240
DATALOG_INDEX DATALOG 168550400
DEVELOPMENT DEVSUPP 73728
DT_DATA BUSOBJECTS 4259840
DT_DATA DT 1496121344
DT_INDEX DT 54501376
FBINT_DATA FBINT 819363840
FBINT_INDEX FBINT 172482560