set pagesize 200
col segment_name format a30
col tablespace_name format a30
select SEGMENT_NAME, SEGMENT_TYPE, TABLESPACE_NAME, MB from
(select segment_name, segment_type, tablespace_name,bytes/1024/1024 MB, rank() over(order by bytes desc) srank from dba_segments) where srank <=10;
Tablespace Allocated
SEGMENT_NAME SEGMENT_TYPE Name MB
-------------------- ------------------ -------------------- ---------
IDL_UB1$ TABLE SYSTEM 240
SOURCE$ TABLE SYSTEM 64
SYS_LOB0000056487C00 LOBSEGMENT SYSAUX 57
025$$
IDL_UB2$ TABLE SYSTEM 30
SYS_LOB0000062550C00 LOBSEGMENT SYSAUX 26
006$$
C_TOID_VERSION# CLUSTER SYSTEM 23
SYS_LOB0000064027C00 LOBSEGMENT SYSAUX 14
004$$
_SYSSMU5_538557934$ TYPE2 UNDO UNDOTBS1 14
JAVA$MC$ TABLE SYSTEM 13
CUSTOMERS TABLE EXAMPLE 12
I_SOURCE1 INDEX SYSTEM 12
11 rows selected.
No comments:
Post a Comment