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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
