1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| SQL> SELECT A.tablespace_Name, A.Alloue, B.Occupe, C.Libre
2 FROM (select tablespace_name, sum(bytes)/1024/1024 AS ALLOUE from dba_data_files group by tablespace_name) a,
3 (select tablespace_name, Sum(bytes)/1024/1024 AS OCCUPE from dba_segments group by tablespace_name) b,
4 (select tablespace_name, Sum(bytes)/1024/1024 AS LIBRE from dba_free_space group by tablespace_name) c
5 WHERE B.tablespace_Name = A.tablespace_Name
6 AND C.Tablespace_Name = B.Tablespace_Name;
TABLESPACE_NAME ALLOUE OCCUPE LIBRE
------------------------------ ---------- ---------- ----------
C0763_DATPCAP1 11392 9462 1924
C0763_INDPCAP1 10112 9591,5 514,5
UNDOTBS1 550 99,25 449,75
SYSAUX 860 816,875 42,25
DATBCB1 64 ,5 62,5
INDSAREF1 256 192,5 72,5
SYSTEM 960 847,5 111,5
C0763_DATLOB1 6848 6483 353
C0763Q_DATPCAP1 3200 3038 156
DATOFIRE1 10 5 4
DATSAREF1 192 169 43,5
TABLESPACE_NAME ALLOUE OCCUPE LIBRE
------------------------------ ---------- ---------- ----------
C0763_DATBO1 128 25 101
C0763Q_INDPCAP1 5504 5221 277
C0763Q_DATLOB1 1088 995,5 80,5
14 ligne(s) sÚlectionnÚe(s). |
Partager