Perl For Oracle Dbas

Perl is a very powerful tool for Oracle database administrators but too fewDBAs realize how helpful Perl can be in managing monitoring and tuning Oracledatabase... » 

Perl is a very powerful tool for Oracle database administrators but too fewDBAs realize how helpful Perl can be in managing monitoring and tuning Oracledatabases. Whether youre responsible for Oracle9i Oracle8i or earlierdatabases youll find Perl an invaluable addition to your databaseadministration arsenal. You dont need to be a Perl expert to use the excellentapplications and scripts described in Perl for Oracle DBAs. The book explainswhat you need to know about Perl provides a wealth of readytouse scriptsdeveloped especially for Oracle DBAs and suggests many resources for furtherexploration. The book covers The Perl language an introduction to Perlits rich history and culture and its extensive text processing and datatransformation capabilities. The PerlOracle architecture Detailedinformation about Perl DBI DBDOracle the Oracle Call Interface OCIOracleOCI extproc_perl and mod_perl the modules that allow Perl programsto communicate with Oracle databases. Perl applications for Oracle DBAs Profiles of the best Perl open source applications available for use andcustomization by Oracle DBAs PerlTk OraExplain StatsView Orac DDLOracle SchemaDiff Senora DBDChart SchemaViewPlus Oracletool KarmaEmbperl and Mason. The Perl Database Administration PDBA Toolkit acomprehensive suite of specialized readytouse scripts designed to helpOracle DBAs perform both routine and specialpurpose administrative tasksmonitoring the Oracle alert log and databases creating and managing Oracleuser accounts maintaining indexes and extents extracting DDL and datatroubleshooting and tuning database problems and much more. The book alsoexplains how Oracle DBAs and developers can extend the toolkit and solve theirown database administration problems using Perl. «