Daily Archivelog Generation and size: with daily_summary as ( select trunc(COMPLETION_TIME,'DD') Day, thread#, round(sum(BLOCKSBLOCK_SIZE)/1048576) MB,count() Archives_Generated from v$archived_log where dest_id=1 group by trunc(COMPLETION_TIME,'DD'),thread# ) select round(sum(mb)/(max(day) - min(day))) AVG_DAILY_MB from…

Error ./ggsci: error while loading shared libraries: libnnz19.so: cannot open shared object file: No such file or directory Solution export LD_LIBRARY_PATH=$ORACLE_HOME/libldd ggsci ORACLE Set DB Env which is configured for…