set linesize 500
col file_name for a65
col tablespace_name for a25
col size(M) for 999999999
select file_name, tablespace_name, bytes/1024/1024 as "size(M)",autoextensible from dba_data_files
union all
select file_name, tablespace_name, bytes/1024/1024 as "size(M)",autoextensible from dba_temp_files order by 2,1
;
col file_name for a65
col tablespace_name for a25
col size(M) for 999999999
select file_name, tablespace_name, bytes/1024/1024 as "size(M)",autoextensible from dba_data_files
union all
select file_name, tablespace_name, bytes/1024/1024 as "size(M)",autoextensible from dba_temp_files order by 2,1
;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/27042095/viewspace-1264014/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/27042095/viewspace-1264014/