7) # "DATABASE GROWN ON LASTS MONTHS"

7) # "DATABASE GROWN ON LASTS MONTHS"

echo ${ECHO} ">--------------------------------------------------------------------------------------------------${RED} ${OPTION} ${BLACK}"
echo ${ECHO} "${RED} DATABASE GROWN ON LASTS MONTHS ${BLACK}"
echo ${ECHO} ">--------------------------------------------------------------------------------------------------${RED} ${OPTION} ${BLACK}"
${LOADING}
if [ ${DBVERSION} = "12" ]
then
PDB=$(sqlplus -S /nolog <<EOF
conn / as sysdba
set pagesize 0 linesize 32767 feedback off verify off heading off echo off 
SELECT NAME FROM V\$CONTAINERS ORDER BY CON_ID, NAME;
quit;
END)
# echo -e "\n${PDB}" | tail +2
echo ${ECHO} ">--------------------------------------------------------------------------------------------------${RED} ${OPTION} ${BLACK}"
echo ${ECHO} "${RED} -- SELECT YOUR DATABASE [ CDB$ROOT / PDB ] ${BLACK} --"
echo ${ECHO} ">--------------------------------------------------------------------------------------------------${RED} ${OPTION} ${BLACK}"
select SET_PDB in ${PDB}
do
  PPDB=${SET_PDB}
  break 1
done
echo ${ECHO} ">--------------------------------------------------------------------------------------------------${RED} ${OPTION} ${BLACK}"
echo ${ECHO} " -- YOUR DATABASE SELECTED IS: ${RED} ${PPDB} ${BLACK} --"
echo ${ECHO} ">--------------------------------------------------------------------------------------------------${RED} ${OPTION} ${BLACK}"
sqlplus -S /nolog <<EOF
conn / as sysdba
alter session set container=${PPDB};
set pages 700 lines 700 timing on colsep '|'
col month for a20
col GROWTH_MB format 999,999,999,999,999
col GROWTH_GB format 999,999,999,999,999
col GROWTH_MB for a25
col GROWTH_GB for a25
exec dbms_application_info.set_action('DB growth');
alter session set nls_date_format='dd/mm/yyyy';
SELECT trunc(creation_time, 'MM') month
  , to_char(round(sum(bytes/1024/1024)), '9G999G999') growth_mb
  , to_char(round(sum(bytes/1024/1024/1024)), '9G999G999') growth_gb
FROM v\$datafile
GROUP BY trunc(creation_time, 'MM')
ORDER BY trunc(creation_time, 'MM');
quit;
EOF
else
sqlplus -S /nolog <<EOF
conn / as sysdba
set pages 700 lines 700 timing on colsep '|'
col month for a20
col GROWTH_MB format 999,999,999,999,999
col GROWTH_GB format 999,999,999,999,999
col GROWTH_MB for a25
col GROWTH_GB for a25
exec dbms_application_info.set_action('DB growth');
alter session set nls_date_format='dd/mm/yyyy';
SELECT trunc(creation_time, 'MM') month
  , to_char(round(sum(bytes/1024/1024)), '9G999G999') growth_mb
  , to_char(round(sum(bytes/1024/1024/1024)), '9G999G999') growth_gb
FROM v\$datafile
GROUP BY trunc(creation_time, 'MM')
ORDER BY trunc(creation_time, 'MM');
quit;
EOF
fi