Re: Perl DBA Tools

Hi Jared,

A few things we use Perl for:

• watchfs.pl

This thing monitors db related file systems and alerts (via our NOC) if thresholds are exceeded. Thresholds managed in dynamic config file.

• process_ora_trace.pl

A one off that helped us w/a vendor. Takes trace output files for a database (ie: entire db in trace mode), scans through em', figures out who's executing what (uid) and lists the SQL statements by user.

• watchdbms.pl

Daemon checking database services

• check_dbup.pl

Tool used by our Unix gang in outages when they restart nodes and need to verify database services.

• baseline_main.pl (and various sub-programs)

Performance tool that works on deltas (ie: run it once to capture beginning stats and again for end stats. Similar in concept to utlestat/bstat). Nitty gritty detail down to waits, latches, buffer pools, blah blah. Output is in html w/a table of contents. Very handy. Delta info stored into a repository instance.

• dbmonitor.pl

Takes capacity stats captured by a ksh script (using dbms_space) and creates html tables showing growth for objects and at tablespace level.

ksh is cool and we have tons of structured scripts for all else we need - but Perl is just so much more fun.

HTH, Casey ...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Casey Dyke
  INET: cdyke_at_excitehome.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).