set linesize 200
set pagesize 200
col tablespace_name format a20
col file_name format a50
select
tablespace_name,
file_name,
round(bytes/1024/1024,2) Size_MB,
round(bytes/1024/1024/1024,2) Size_GB,
Autoextensible,
round((increment_by*8192)/1024/1024,2) NEXT_increment_MB,
round(maxbytes/1024/1024/1024,2) Max_GB
from
dba_data_files
where
tablespace_name='&TBS_in_CAPS'
order by bytes;
No comments:
Post a Comment