#!/bin/bash export ORACLE_BASE=/u01/app/oracle # 오라클의 루트 디렉토리 export ORACLE_SID=orcl # 오라클 인스턴스 이름 (db이름) export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 # 오라클 홈 export PATH=$ORACLE_HOME/bin:$PATH # 오라클 홈 디렉토리가 어딘지 환경설정 sqlplus scott/tiger <<EOF
select t.tablespace_name, t.total_size||'MB' as total_size, f.free_size||'MB' as free_size, round(((t.total_size - f.free_size) / t.total_size) * 100) "used space(%)" from (select tablespace_name, sum(bytes)/1024/1024 total_size from dba_data_files group by tablespace_name) t, (select tablespace_name, sum(bytes)/1024/1024 free_size from dba_free_space group by tablespace_name) f where t.tablespace_name = f.tablespace_name union all select tablespace_name, maxbytes/1024/1024||'MB' as total_size, (maxbytes-user_bytes)/1024/1024||'MB' as free_size, round((user_bytes / maxbytes) * 100) as "used space(%)" from dba_temp_files;
EOF |