shell scripting ⁽²⁾

I have a data collection system that I run against all DBs in my environment nightly. I inherited a script that would just start at the top of the list and SQLPlus into them one by one to collect the data. Well the scope of…

This script will generate dbv commands into a shell script and then execute the shell script. run-dbv.sql: set head off set lines 200 set feedback off set define off spool dbv.sh select 'dbv file='||name||' blocksize = '||block_size|| ' LOGFILE=FILE-'||FILE#||'.LOG' from v$datafile; spool off host chmod…