Verificando tamanho total datafile
|
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 |
select tablespace_name, sum(bytes)/1024/1024 as "TAMANHO(MB)" from dba_data_files group by tablespace_name order by sum(bytes); TABLESPACE_NAME TAMANHO(MB) ------------------------------ ----------- USERS 5 INTRANET 100 NFELOB 200 RHMETA_INDEX 600 NFEINDICES 900 SYSAUX 1450 NFEDADOS 1600 SYSTEM 2010 ORCLINDICES 2700 REORG_LOB 7400 TOOLS 8300 UNDOTBS1 8405 REORG_DADOS 12800 RHMETA 32767.9844 REORG_INDICES 42600 ORCLDADOS 141300 16 rows selected. |
Verificando espaço disponível DATAFILES
|
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 |
select tablespace_name, sum(bytes)/1024/1024 as "TAMANHO(MB)" from dba_free_space group by tablespace_name order by sum(bytes); TABLESPACE_NAME TAMANHO(MB) ------------------------------ ----------- SYSTEM .1875 USERS 3.0625 NFEINDICES 56 RHMETA 60.0625 SYSAUX 76.4375 RHMETA_INDEX 77.3125 NFEDADOS 86.0625 NFELOB 88.375 INTRANET 94.875 ORCLINDICES 220.75 REORG_LOB 403.5 TOOLS 419.25 REORG_DADOS 669.125 REORG_INDICES 2053.6875 ORCLDADOS 3503.375 UNDOTBS1 8043.25 16 rows selected. |
Adicionando DATAFILE
|
1 2 3 |
SYS@ORCL > ALTER TABLESPACE RHMETA ADD DATAFILE '/u01/oracle/oradata/ORCL/tbs_rhmeta_02.dbf' size 100m AUTOEXTEND ON; Tablespace altered. |
Verificando novamente espaço disponível DATAFILES
|
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 |
SYS@ORCL > select tablespace_name, sum(bytes)/1024/1024 as "TAMANHO(MB)" from dba_free_space group by tablespace_name order by sum(bytes); TABLESPACE_NAME TAMANHO(MB) ------------------------------ ----------- SYSTEM .1875 USERS 3.0625 NFEINDICES 56 SYSAUX 76.4375 RHMETA_INDEX 77.3125 NFEDADOS 86.0625 NFELOB 88.375 INTRANET 94.875 ORCLINDICES 220.75 REORG_LOB 403.5 TOOLS 419.25 REORG_DADOS 669.125 RHMETA 1695.0625 REORG_INDICES 1989.6875 ORCLDADOS 3503.375 UNDOTBS1 8113.25 16 rows selected. |