select bytes from dba_free_space where tablespace_name='SYSTEM'
解决方案 »
- oracle触发器中:old与:new用法
- select * from dept ,dept e各位老大帮帮忙吧
- 救急阿 一个分组问题
- 怎么用一条SQL语句算出平均分来呢
- 这种sql怎么写~请高手指点
- 这条update语句有没有使用索引?在线等待
- 新手问题2:在设置了pre_page_sga = true后重起Oracle失败,错误是 ORA-00445:background process "PMON" did not start after 120 seco
- 在线提问,这道题用sql语句该怎么写?
- 创建一数据库实例之后,在Console,DBA Studio都找不到,但在sql plus却可以连接.
- 在oracle中如何设置自增长的字段?
- 数据库删除不了
- 重发关于表空间和用户的关系的疑惑
2、select sum(bytes)/(1024*1024) as free_space, tablespace_name
from dba_free_space
group by tablespace_name;
tablespace_name,
sum(blocks) as free_blk,
trunc(sum(bytes)/(1024*1024)) as free_m,
max(bytes)/(1024) as big_chunk_k,
count(*) as num_chunks
from
dba_free_space
where
tablespace_name='SYSTEM'
group by
tablespace_name