Skip to content

Perl for Oracle DBAs Perl Scripts, Applications and Tips for Database Administrators

Best in textbook rentals since 2012!

ISBN-10: 0596002106

ISBN-13: 9780596002107

Edition: 2002

Authors: Andy Duncan, Jared Still

List price: $49.99
Blue ribbon 30 day, 100% satisfaction guarantee!
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle databases. Whether you're responsible for Oracle9i, Oracle8i, or earlier databases, you'll find Perl an invaluable addition to your database administration arsenal. You don't need to be a Perl expert to use the excellent applications and scripts described in Perl for Oracle DBAs. The book explains what you need to know about Perl, provides a wealth of ready-to-use scripts developed especially for Oracle DBAs, and suggests many resources for further exploration. The book covers: The Perl language -- an introduction to Perl, its rich…    
Customers also bought

Book details

List price: $49.99
Copyright year: 2002
Publisher: O'Reilly Media, Incorporated
Publication date: 9/10/2002
Binding: Paperback
Pages: 622
Size: 7.00" wide x 9.19" long x 1.17" tall
Weight: 2.002
Language: English

Andy Duncanis an award-winning writer and lifelong Southerner whose fiction and nonfiction works have appeared in numerous books and periodicals. His first book,Beluthahatchie and Other Stories(Golden Gryphon Press, 2000), won the 2001 World Fantasy Award for Best Collection. He lives in Northport, Alabama.

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…    

Preface
Introducing Perl for Oracle
Perl Meets Oracle
What is Perl?
The Perl/Oracle Architecture
Perl for Oracle DBAs
For Further Information
Installing Perl
Installing Perl
Installing Perl DBI
Running Perl DBI
Installing Cygwin
Extending Perl
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
Perl Web Extensions
Apache
Oracletool
Karma
Embedding Perl into Apache with mod_perl
mod_perl
Apache::OWA
Embedded Perl Web Scripting
Embperl
Mason
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
Embedding Perl into PL/SQL
Communication Between Perl and PL/SQL
Embedding Perl Within Oracle
The Perl DBA Toolkit
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
Performing Routine DBA Tasks with the PDBA Toolkit
Managing User Accounts
Maintaining Indexes
Killing Sniped Sessions
Managing Extent Usage
Extracting DDL and Data
Monitoring the Database with the PDBA Toolkit
Monitoring the Alert Log
Monitoring the Databases
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
Extending the PDBA Toolkit
Modifying a Script in the Toolkit
Modifying a Module in the Toolkit
Appendixes
The Essential Guide to Perl
The Essential Guide to Perl DBI
The Essential Guide to Regular Expressions
The Essential Guide to Perl Data Munging
Index