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 |