[sqlplus] SELECT 예제 (sqlplus EOF 사용)
sqlplus 아이디/비번 << EOF
set feedback off
set linesize 150
col “Tablespace Name” format a20
col “Bytes(MB)” format 999,999,999.99
col “Used(MB)” format 999,999,999.99
col “Percent(%)” format 999999.99
col “Free(MB)” format 999,999,999.99
col “Free(%)” format 9999.99
select ddf.tablespace_name “Tablespace Name”,
ddf.bytes/1024/1024 “Bytes(MB)”,
(ddf.bytes – dfs.bytes)/1024/1024 “Used(MB)”,
round(((ddf.bytes – dfs.bytes) / ddf.bytes) * 100, 2) “Percent(%)”,
dfs.bytes/1024/1024 “Free(MB)”,
round((1 – ((ddf.bytes – dfs.bytes) / ddf.bytes)) * 100, 2) “Free(%)”
from (select tablespace_name, sum(bytes) bytes
from dba_data_files
group by tablespace_name) ddf,
(select tablespace_name, sum(bytes) bytes
from dba_free_space
group by tablespace_name) dfs
where ddf.tablespace_name = dfs.tablespace_name and dfs.tablespace_name not like ‘TS%’
order by ((ddf.bytes-dfs.bytes)/ddf.bytes) desc
EOF