dba_tablespace_usage_metricsTag Archive

This script will show  tablespaces from all databases in server which are full by 85 percent.This script will take care autoextend on clause.This means it will show tablespace usage if growth is exceeding autoextended space. 1.The shell script:- for j in ORCL1 ORCL2 do export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=/u01/app/oracle/product/12.1.0/db_1 export ORACLE_SID=$i… Continue Reading Tablespace usage considering autoextend on