This third part of the book describes the Perl Database
Administration (PDBA) Toolkit, a set of Perl scripts and reusable
modules that we've developed to help Oracle DBAs
perform both routine database administration and more advanced
monitoring and tuning. It consists of the following chapters:
Chapter 9 introduces the components of the Perl
Database Administration Toolkit 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 them to suit your specific database administration
needs.
