sqlplus -S '/as sysdba' <
col TABLESPACE format a10;
SELECT UPPER(F.TABLESPACE_NAME) "TABLESPACE",
D.TOT_GROOTTE_MB "Total(M)",
D.TOT_GROOTTE_MB - F.TOTAL_BYTES "Used(M)",
TO_CHAR(ROUND((D.TOT_GROOTTE_MB - F.TOTAL_BYTES) / D.TOT_GROOTTE_MB * 100,0), '990')||'%' "Percentage",
F.TOTAL_BYTES "Free(M)",
F.MAX_BYTES "Max Size(M)"
FROM (SELECT TABLESPACE_NAME,
ROUND(SUM(BYTES) / (1024 * 1024), 2) TOTAL_BYTES,
ROUND(MAX(BYTES) / (1024 * 1024), 2) MAX_BYTES
FROM SYS.DBA_FREE_SPACE
GROUP BY TABLESPACE_NAME) F,
(SELECT DD.TABLESPACE_NAME,
ROUND(SUM(DD.BYTES) / (1024 * 1024), 2) TOT_GROOTTE_MB
FROM SYS.DBA_DATA_FILES DD
GROUP BY DD.TABLESPACE_NAME) D
WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME
ORDER BY 4 DESC;
exit
!
echo "
sqlplus -S '/as sysdba' <
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select thread#,max(first_time),max(sequence#) from v\$archived_log group by thread#;
exit
!
echo "
sqlplus -S '/as sysdba' <
select round(sum(a.bytes_alloc)/1024/1024/1024,2) "TBS_ALLOCT_TOTAL(G)",
round( (sum(a.bytes_alloc)-sum(nvl(b.bytes_free, 0)))/1024/1024/1024,3) "TBS_USED_TOTAL(G)"
from ( select f.tablespace_name,
sum(f.bytes) bytes_alloc
from dba_data_files f
group by tablespace_name) a,
( select f.tablespace_name,
sum(f.bytes) bytes_free
from dba_free_space f
group by tablespace_name) b
where a.tablespace_name = b.tablespace_name (+);
exit
!
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23757700/viewspace-708926/,如需轉載,請註明出處,否則將追究法律責任。