unix (2)

Dave

Quickie script to run dbv on your database...

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…

Dave

Automagically Graphing on Linux

So my last post was about administration on Linux. After running Oracle on Windows for way too many years we migrated our Oracle systems to 64-bit Linux over the past year. Now that we're on Linux I needed a lightweight way to capture and graph…