Team LiB   Previous Section   Next Section

Structure of This Book

This book is divided into four parts:

Part I

  • Chapter 1 introduces the Perl language and explains why it is such a helpful language for Oracle database administrators. It also provides an overview of the main components of the Perl/Oracle architecture.

  • Chapter 2 describes how to install Perl on Unix and Win32 systems. It also describes how to install Cygwin, a Unix-like development environment you can install on your Win32 machine.

Part II

  • Chapter 3 describes Perl/Tk, an extensive GUI-based toolkit for Perl, as well as a number of applications that provide Oracle DBAs with graphically oriented tools for performing database administration. These include OraExplain, StatsView, Orac, DDL::Oracle, SchemaDiff, Senora, DBD::Chart, SchemaView-Plus, and a variety of Perl GUI integrated development environments (IDEs) and debuggers.

  • Chapter 4 discusses the relationship between Perl and the Apache web server, and focuses on two Oracle applications that use a web browser as their user interface: Oracletool and Karma.

  • Chapter 5 explains how the use of Apache's mod_perl module can greatly improve the performance of Perl web-based CGI (Common Gateway Interface) scripts used with Oracle. This chapter also covers several related Apache modules: Apache::Registry, Apache::DBI, and Apache::OWA (used to connect mod_perl to Oracle's PL/SQL Web Toolkit).

  • Chapter 6 describes two applications, Embperl and Mason, that demonstrate the advantages of embedded scripting, a method that allows Perl code to be embedded within web pages. These tools provide a mechanism for filling your production web pages with dynamic Oracle data and creating your own Oracle web tools, while separating content from design issues.

  • Chapter 7 covers Oracle::OCI, a Perl module that provides a more extensive interface to Oracle's Oracle Call Interface (OCI) than is possible with Perl DBI.

  • Chapter 8 discusses extproc_perl, a Perl module that communicates with the Oracle PL/SQL language's external procedure C library system (known as EXTPROC). This module and the others described here allow Perl code to be embedded directly in PL/SQL programs.

Part III

  • Chapter 9 introduces the components of the Perl Database Administration Toolkit (PDBA) and explains how to install it and build the toolkit's password server.

  • Chapter 10 describes the toolkit's Perl scripts that help DBAs perform day-to-day administration. We'll cover managing user accounts, maintaining indexes, killing sniped sessions, managing extent usage, and extracting DDL (Data Definition Language) and data.

  • Chapter 11 describes the toolkit's Perl scripts that can be used to monitor both the Oracle alert log (containing database error and status messages) and the connectivity of the databases.

  • Chapter 12 describes the toolkit's Perl scripts that allow you to build a repository in which to store information about the many changes made to an Oracle database's tables, indexes, roles, schemas, and other objects.

  • Chapter 13 provides information that will be helpful if you decide to modify any of the scripts or modules in the toolkit. We'll take a detailed look inside one of the toolkit's scripts and modules and illustrate how you can change it to suit your specific database administration needs.

Part IV

  • Appendix A summarizes basic Perl syntax, including object-oriented features.

  • Appendix B presents the main Perl DBI application programming interface (API) functions.

  • Appendix C describes the basics of regular expressions (regexes), patterns of literals and metacharacters used extensively by Perl for pattern matching.

  • Appendix D summarizes the Perl data-munging modules that are helpful in formatting and transforming data for data warehouses and other such Oracle applications; it includes sections on numeric, date, conversion, and XML modules.

    Team LiB   Previous Section   Next Section