Menu de navegação

[mguedesParticipante]

Qual o comando para eu poder listar todos os tablespaces do BD no sqlplus???

[RodrigofsParticipante]

Olá boa noite mguedes

existem algumas views que podem te dar essa informação. As principais são:

v$tablespace
dba_tablespaces
dba_data_filles

Para listar todas as tablespaces de forma simples faça:

select name from v$tablespace;

Abraço!

[jurupocParticipante]


select
substr(a.tablespace_name,1,20) "Tablespaces",
(b.BYTES/1048576) as "TotalMB",
(b.BYTES/1048576)-(c.BYTES/1048576) as "UsedMB",
(c.BYTES/1048576) as "FreeMB"
from dba_tablespaces a,
(select tablespace_name,sum(bytes) as "BYTES"
from dba_data_files
group by tablespace_name ) b,
(select tablespace_name,sum(bytes) as "BYTES"
from dba_free_space
group by tablespace_name) c
where
a.tablespace_name = b.tablespace_name(+) and
b.tablespace_name = c.tablespace_name(+)
order by
a.tablespace_name;


[Autor]

Posts