Table of Contents

 

	Table of Contents
	Index
	Reviews
	Reader Reviews
	Errata

Perl for Oracle DBAs
By Andy  Duncan, Jared  Still
Publisher	: O'Reilly
Pub Date	: August 2002
ISBN	: 0-596-00210-6
Pages	: 620
Slots	: 1			Copyright
		Preface
			Audience for This Book
			Which Platform and Version?
			Structure of This Book
			About the Perl DBA Toolkit and Examples
			Conventions Used in This Book
			Comments and Questions
			Acknowledgments
		Part I:   Introducing Perl for Oracle
			Chapter 1.   Perl Meets Oracle
				Section 1.1.   What is Perl?
				Section 1.2.   The Perl/Oracle Architecture
				Section 1.3.   Perl for Oracle DBAs
				Section 1.4.   For Further Information
			Chapter 2.   Installing Perl
				Section 2.1.   Installing Perl
				Section 2.2.   Installing Perl DBI
				Section 2.3.   Running Perl DBI
				Section 2.4.   Installing Cygwin
		Part II:   Extending Perl
			Chapter 3.   Perl GUI Extensions
				Section 3.1.   Perl/Tk
				Section 3.2.   OraExplain
				Section 3.3.   StatsView
				Section 3.4.   Orac
				Section 3.5.   DDL::Oracle
				Section 3.6.   SchemaDiff
				Section 3.7.   Senora
				Section 3.8.   DBD::Chart
				Section 3.9.   SchemaView-Plus
				Section 3.10.   Open Source Perl IDEs
				Section 3.11.   Open Source Perl GUI Debuggers
			Chapter 4.   Perl Web Extensions
				Section 4.1.   Apache
				Section 4.2.   Oracletool
				Section 4.3.   Karma
			Chapter 5.   Embedding Perl into Apache with mod_perl
				Section 5.1.   mod_perl
				Section 5.2.   Apache::OWA
			Chapter 6.   Embedded Perl Web Scripting
				Section 6.1.   Embperl
				Section 6.2.   Mason
			Chapter 7.   Invoking the Oracle Call Interface with Oracle::OCI
				Section 7.1.   What is Oracle::OCI?
				Section 7.2.   What Is OCI?
				Section 7.3.   Installing Oracle::OCI
				Section 7.4.   Coding with Oracle::OCI
				Section 7.5.   The Future of Oracle::OCI
			Chapter 8.   Embedding Perl into PL/SQL
				Section 8.1.   Communication Between Perl and PL/SQL
				Section 8.2.   Embedding Perl Within Oracle
		Part III:   The Perl DBA Toolkit
			Chapter 9.   Installing the PDBA Toolkit
				Section 9.1.   Introducing the PDBA Toolkit
				Section 9.2.   Toolkit Modules
				Section 9.3.   Installing the PDBA Toolkit for Unix
				Section 9.4.   Installing the PDBA Toolkit for Win32
				Section 9.5.   Configuring the PDBA Toolkit
			Chapter 10.   Performing Routine DBA Tasks with the PDBA Toolkit
				Section 10.1.   Managing User Accounts
				Section 10.2.   Maintaining Indexes
				Section 10.3.   Killing Sniped Sessions
				Section 10.4.   Managing Extent Usage
				Section 10.5.   Extracting DDL and Data
			Chapter 11.   Monitoring the Database with the PDBA Toolkit
				Section 11.1.   Monitoring the Alert Log
				Section 11.2.   Monitoring the Databases
			Chapter 12.   Building a Database Repository with the PDBA Toolkit
				Section 12.1.   Repository Table Structure
				Section 12.2.   Installing the Repository
				Section 12.3.   Loading the Repository with Data
				Section 12.4.   Reporting on Database Changes
				Section 12.5.   Reporting on SQL Execution Plans
			Chapter 13.   Extending the PDBA Toolkit
				Section 13.1.   Modifying a Script in the Toolkit
				Section 13.2.   Modifying a Module in the Toolkit
		Part IV:   Appendixes
			Appendix A.   The Essential Guide to Perl
				Obtaining Online Information
				Running Perl Scripts
				Perl Variable Types: Scalars, Arrays, and Hashes
				Perl Contexts: Void, Scalar, List, and Boolean
				Program and Subroutine Parameters
				Perl References
				Perl's Object Orientation
			Appendix B.   The Essential Guide to Perl DBI
				DBI Class Methods
				Database Handles ” Preparation
				Statement Handle Methods
				Database Handles ” SQL and Cleanup
				Metadata
				Oracle-Specific Methods
			Appendix C.   The Essential Guide to Regular Expressions
				The Origins of Regular Expressions
				Built-in String Handling Functions
				Regular Expression Concepts
				Metacharacters
				Match Suffixes
			Appendix D.   The Essential Guide to Perl Data Munging
				What Is Data Munging?
				Data-Munging Example: An Inter-Database Transfer
				Numeric Modules
				Date Modules
				Conversion Modules
				XML Modules
		Colophon
		Index