03.02. system monitoring

                    <<< Back   Next >>>
1. Checking free space in the file system
[oracle]$
export ORACLE_SID=+ASM
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/19.0/grid
$ORACLE_HOME/bin/sqlplus '/ as sysdba' <<EOF
set lin 5000 pages 5000;
select fs_name,vol_device, round(total_mb/1024,2) as total_Gb, round(free_mb/1024,2) as free_Gb from V\$ASM_ACFSVOLUMES;
EOF

$ORACLE_HOME/bin/sqlplus '/ as sysdba' <<EOF

set lin 5000 pages 5000;

select fs_name,round(total_size/1024,2) total_size_Gb, round(total_free/1024,2) total_free_Gb, round(total_snap_space_usage/1024,2) as snap_size_Gb from V\$ASM_FILESYSTEM;

EOF

2. Checking snapshots sizes and quota usage

$ORACLE_HOME/bin/sqlplus '/ as sysdba' <<EOF
set lin 5000 pages 5000;
select snap_name,parent,type,to_char(create_time,'dd.mm.yyyy hh24:mi') create_time, round(additional_storage/1024,2) as sizeSNAP_Gb,
round(quota/1024,2) quota_Gb, round((additional_storage/quota)*100,2) as Util_pct
from V\$ASM_ACFSSNAPSHOTS where quota>0 order by create_time;
EOF

3. Checking free space in the file system from FS

[oracle@]: 
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/19.0/grid
/sbin/acfsutil info fs

4. Checking snapshots sizes and quota usage from FS
[oracle@]: 
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/19.0/grid
acfsutil snap info /u02/oradata/bank

                    <<< Back   Next >>>