Perl for Oracle Dbas

by Duncan, Andy

• ISBN13: 9780596002107
• ISBN10: 0596002106
• Edition: 1st
• Format: Paperback
• Copyright: 2002-08-01
• Publisher: Oreilly & Associates Inc

Summary

Perl is a very helpful tool for Oracle database administrators, but too few DBAs realize how powerful Perl can be. Perl for Oracle DBAs describes what DBAs need to know about Perl and explains how they can use this popular open source language to manage, monitor, and tune their Oracle databases. The book also describes the Oracle/Perl software modules that tie these two environments together - for example, Oracle Call Interface (OCI), Perl DataBase Interface (DBI), DBD-Oracle, and mod_perl, etc. The book comes with a toolkit containing more than 100 ready-to-use programs that DBAs can put to immediate use in their Linux or Windows systems.

Author Biography

Andy Duncan is the coauthor of Oracle & Open Source (O'Reilly, 2001), as well as Perl for Oracle DBAs (O'Reilly, 2002). The first book arose after Andy's creation, in 1998, of the Orac Perl/Tk tool for Oracle DBAs. Since then, he has worked mainly as an independent development and DBA consultant, and has counted both Oracle Corporation and Sun Microsystems among his long-term clients. In addition to performing Oracle, Perl, and Java consultancy work, Andy teaches as a senior instructor for Learning Tree International, covering both introductory and advanced Perl courses. He lives in Oxfordshire, England.

Jared Still has been an Oracle DBA in health insurance and manufacturing environments since 1994 (and version 7.0.13 of Oracle). He first began dabbling with Perl in 1993 and it was love at first sight. Perl became an integral part of his Oracle toolkit when it was used to rapidly prototype and implement complex reporting based on data in Oracle databases. Jared has been working with databases of various ilks since 1988, and along the way has also worked as a Unix system administrator. When not riding herd on the databases at the OK Corral, he likes to spend time tinkering on his car, fly fishing, or sitting on the deck in the backyard at his home doing absolutely nothing. He can be reached at [e-mail].

Table of Contents

Preface	ix
Part I. Introducing Perl for Oracle
Perl Meets Oracle	3	(25)
What is Perl?	4	(6)
The Perl/Oracle Architecture	10	(5)
Perl for Oracle DBAs	15	(9)
For Further Information	24	(4)
Installing Perl	28	(37)
Installing Perl	28	(10)
Installing Perl DBI	38	(10)
Running Perl DBI	48	(3)
Installing Cygwin	51	(14)
Part II. Extending Perl
Perl GUI Extensions	65	(45)
Perl/Tk	66	(6)
OraExplain	72	(2)
StatsView	74	(8)
Orac	82	(2)
DDL::Oracle	84	(6)
SchemaDiff	90	(2)
Senora	92	(3)
DBD::Chart	95	(9)
SchemaView-Plus	104	(3)
Open Source Perl IDEs	107	(1)
Open Source Perl GUI Debuggers	108	(2)
Perl Web Extensions	110	(26)
Apache	111	(7)
Oracletool	118	(9)
Karma	127	(9)
Embedding Perl into Apache with mod_perl	136	(25)
Mod_perl	137	(18)
Apache::OWA	155	(6)
Embedded Perl Web Scripting	161	(17)
Embperl	162	(7)
Mason	169	(9)
Invoking the Oracle Call Interface with Oracle::OCI	178	(23)
What is Oracle::OCI?	179	(1)
What Is OCI?	180	(5)
Installing Oracle::OCI	185	(5)
Coding with Oracle::OCI	190	(8)
The Future of Oracle::OCI	198	(3)
Embedding Perl into PL/SQL	201	(26)
Communication Between Perl and PL/SQL	202	(2)
Embedding Perl Within Oracle	204	(23)
Part III. The Perl DBA Toolkit
Installing the PDBA Toolkit	227	(52)
Introducing the PDBA Toolkit	228	(4)
Toolkit Modules	232	(25)
Installing the PDBA Toolkit for Unix	257	(4)
Installing the PDBA Toolkit for Win32	261	(4)
Configuring the PDBA Toolkit	265	(14)
Performing Routine DBA Tasks with the PDBA Toolkit	279	(49)
Managing User Accounts	280	(17)
Maintaining Indexes	297	(8)
Killing Sniped Sessions	305	(7)
Managing Extent Usage	312	(3)
Extracting DDL and Data	315	(13)
Monitoring the Database with the PDBA Toolkit	328	(38)
Monitoring the Alert Log	328	(14)
Monitoring the Databases	342	(24)
Building a Database Repository with the PDBA Toolkit	366	(37)
Repository Table Structure	367	(2)
Installing the Repository	369	(5)
Loading the Repository with Data	374	(3)
Reporting on Database Changes	377	(15)
Reporting on SQL Execution Plans	392	(11)
Extending the PDBA Toolkit	403	(172)
Modifying a Script in the Toolkit	404	(17)
Modifying a Module in the Toolkit	421	(18)
Part IV. Appendixes
A. The Essential Guide to Perl	439	(20)
B. The Essential Guide to Perl DBI	459	(23)
C. The Essential Guide to Regular Expressions	482	(39)
D. The Essential Guide to Perl Data Munging	521	(54)
Index	575