新人请教一个关于Oracle的问题~

七号情报员

也是朋友托我问的.
一个进程起不来,据说跟数据库空间已满有关
请问如何查看数据库空间?
谢谢!

sshd

check the alert.log file under the dir returned by
SQL>; show parameter background_dump_dest
pay attention to the ORA-XXXX errors

lmtok

select a.tablespace_name, round(a.total_size) "total_size(MB)",
round(a.total_size)-round(b.free_size,3) "used_size(MB)",
round(b.free_size,3) "free_size(MB)", round(b.free_size/total_size*100,2)||'%' free_rate
from ( select tablespace_name, sum(bytes)/1024/1024 total_size
        from dba_data_files
        group by tablespace_name ) a,
        ( select tablespace_name, sum(bytes)/1024/1024 free_size
          from dba_free_space
          group by tablespace_name ) b
        where a.tablespace_name = b.tablespace_name(+);