linux查看表空间文件,查看表空间

1、查看表空间

select

a.tablespace_name,

a.file_name,

a.total "Total(MB)",

round(a.total-b.Free_Space) "Used(MB)",

round(((a.total-b.Free_Space)/a.total)*100,2) "Used(%)",

a.auto_extend

from

(select

FILE_ID,

tablespace_name,

file_name,

bytes/(1024*1024) Total,

AUTOEXTENSIBLE auto_extend

from

dba_data_files ddf) a,

(select

file_id,

sum(bytes)/(1024*1024) Free_Space

from

dba_free_space

group by file_id) b

where

a.file_id=b.file_id

order by a.tablespace_name;

2、查看数据文件扩展信息

select tablespace_name,file_name,round(bytes/(1024*1024),0) total_space,

AUTOEXTENSIBLE,increment_by,maxbytes from dba_data_files order by tablespace_name;

3、查看flash_recove用了多少？

SELECT     name file_name,

space_limit/1024/1024 AS "quota(MB)",

space_used/1024/1024 AS "used(MB)",

space_reclaimable/1024/1024 AS reclaimable,

number_of_files AS file_num

FROM  v$recovery_file_dest ;