Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Perl for Oracle DBAs....wow.
Here's the TOC.
Not too sure about an abstract, or what I can post here without upsetting O'Reilly's apple cart. I'll find out. I've put a few comments in the toolkit part of the TOC.
Jared
These chapter numbers are not correct. I couldn't find a corrected TOC in Word, so this is somewhat different than reality. Close enough for now though.
Table of Contents
Part I: Introducing Perl for Oracle
1. Perl Meets Oracle
2. Installing Perl
Part II: Extending Perl
3. Perl GUI Extensions 4. Perl Web Extensions 5. Embedding Perl into Apache with mod_perl 6. Embedded Perl Web Scripting 7. Invoking the Oracle Call Interface with Oracle::OCI 8. Embedding Perl into PL/SQL
Part III: The Perl Database Administration Toolkit
9. Installing the PDBA Toolkit
How to install the modules and scripts, and a number of
required supporting modules, for Win32 and Unix.
How to setup the password server. Configurable for database, server and account names. Allows restricting some passwords to certain users. Only authenticated password server users allowed access. Passwords sent over the network via RC4 encryption.
Some other stuff.
Store schemas in a repository. Several canned reports to report on changes that may have occurred.
Store SQL and Execution Plans. Find execution paths that have changed over time.
Plan on using a lot of disk space for this stuff. :)
creating and dropping user accounts, including a script to create many at one time.
Extract DDL
sqlunldr.pl - dump a whole schema or selected tables to CSV format, generating SQL*Loader files for each. Handles BLOB's and LONG's upto 32k. One of my favorites. :)
We walk through a script using most of the included modules and give detailed explanations of the code. Probably necessary for writing your own unless you have a lot of Perl experience.
Worth the read just to understand how to use the Password Server modules in your Perl scripts. The command line stuff is easy, but the modules require a bit of explanation, it's kind of tricky.
Part IV: Appendixes
A. The Essential Guide to Perl B. The Essential Guide to Perl DBI C. The Essential Guide to Perl Regular Expressions D. The Essential Guide to Perl Data Munging
Index
Colophon
On Monday 01 July 2002 09:20, Rodd Holman wrote:
> Jared,
>
> What's the possibility of seeing the Table of Contents, or an abstract
> of this? The title seems to have grabbed a lot of interest among us
> all.
>
> Rodd
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: jkstill_at_cybcon.com 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).Received on Tue Jul 02 2002 - 00:58:22 CDT