| 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 |