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.
