Pour lister les tablespaces de la base ainsi que leurs fichiers associés : SELECT FILE_ID, FILE_NAME, STATUS, TABLESPACE_NAME FROM DBA_DATA_FILES ORDER BY FILE_ID; FILE_ID FILE_NAME STATUS TABLESPACE_NAME ———- ———————————- ——— ————— 1 /u01/LSC63/data/system01LSC63.db AVAILABLE SYSTEM 2 /u01/LSC63/data/undo01LSC63.dbf AVAILABLE UNDOTBS1 3 /u01/LSC63/data/sysaux01LSC63.dbf AVAILABLE SYSAUX 4 /u01/LSC63/data/sysaux02LSC63.dbf AVAILABLE SYSAUX 5 /u01/LSC63/data/sysaux03LSC63.dbf AVAILABLE SYSAUX 6 /u01/LSC63/data/users01LSC63.dbf [...]
Tag Archives: tablespaces
Caractéristiques des tablespaces
Posted by DiabloCorps on 12 octobre 2010
0 comments
select a.TABLESPACE_NAME, round(((nvl(sum(b.bytes),0)-nvl(sum(c.free_bytes),0)) / nvl(sum(b.maxbytes),0))*100, 2)||’ %’ « % Utilisation », –a.EXTENT_MANAGEMENT, –a.ALLOCATION_TYPE, –a.BIGFILE, nvl(sum(b.bytes),0)/(1024*1024)||’ Mo’ « Taille », nvl(sum(b.maxbytes),0)/(1024*1024)||’ Mo’ « Taille Max », round((nvl(sum(b.bytes),0)-nvl(sum(c.free_bytes),0))/(1024*1024),1)||’ Mo’ « Utilisés », nvl(sum(b.count_files),0) « Nb fichiers », a.CONTENTS, a.SEGMENT_SPACE_MANAGEMENT, a.STATUS « Statut » from DBA_TABLESPACES a, ( select TABLESPACE_NAME, sum(BYTES) bytes, count(*) count_files, sum(greatest(MAXBYTES,BYTES)) maxbytes from DBA_DATA_FILES group by TABLESPACE_NAME union all select TABLESPACE_NAME, sum(BYTES), count(*), sum(greatest(MAXBYTES,BYTES)) maxbytes from [...]