Perl for Oracle Dbas: Perl Scripts, Applications & Tips for Database Administrators (Paperback)

Part I. Introducing Perl for Oracle

1. Perl Meets Oracle
What is Perl?
The Perl/Oracle Architecture
Perl for Oracle DBAs
For Further Information

2. Installing Perl
Installing Perl
Installing Perl DBI
Running Perl DBI
Installing Cygwin

Part II. Extending Perl

3. Perl GUI Extensions
Perl/Tk
OraExplain
StatsView
Orac
DDL::Oracle
SchemaDiff
Senora
DBD::Chart
SchemaView-Plus
Open Source Perl IDEs
Open Source Perl GUI Debuggers

4. Perl Web Extensions
Apache
Oracletool
Karma

5. Embedding Perl into Apache with mod_perl
mod_perl
Apache::OWA

6. Embedded Perl Web Scripting
Embperl
Mason

7. Invoking the Oracle Call Interface with Oracle::OCI
What is Oracle::OCI?
What Is OCI?
Installing Oracle::OCI
Coding with Oracle::OCI
The Future of Oracle::OCI

8. Embedding Perl into PL/SQL
Communication Between Perl and PL/SQL
Embedding Perl Within Oracle

Part III. The Perl DBA Toolkit

9. Installing the PDBA Toolkit
Introducing the PDBA Toolkit
Toolkit Modules
Installing the PDBA Toolkit for Unix
Installing the PDBA Toolkit for Win32
Configuring the PDBA Toolkit

10. Performing Routine DBA Tasks with the PDBA Toolkit
Managing User Accounts
Maintaining Indexes
Killing Sniped Sessions
Managing Extent Usage
Extracting DDL and Data

11. Monitoring the Database with the PDBA Toolkit
Monitoring the Alert Log
Monitoring the Databases

12. Building a Database Repository with the PDBA Toolkit
Repository Table Structure
Installing the Repository
Loading the Repository with Data
Reporting on Database Changes
Reporting on SQL Execution Plans

13. Extending the PDBA Toolkit
Modifying a Script in the Toolkit
Modifying a Module in the Toolkit

Part IV. Appendixes

A. The Essential Guide to Perl

B. The Essential Guide to Perl DBI

C. The Essential Guide to Regular Expressions

D. The Essential Guide to Perl Data Munging