- Paperback: 622 pages
- Publisher: O'Reilly Media; 1 edition (26 Aug 2002)
- Language English
- ISBN-10: 0596002106
- ISBN-13: 978-0596002107
- Product Dimensions: 23.4 x 17.9 x 3 cm
- Average Customer Review: 5.0 out of 5 stars See all reviews (1 customer review)
- Amazon Bestsellers Rank: 1,171,140 in Books (See Top 100 in Books)
- See Complete Table of Contents
Perl for Oracle DBAs
and over one million other books are available for Amazon Kindle .
Learn more
| |||||||||||||||
Did you know you can trade in your old books for an Amazon.co.uk Gift Card to spend on the things you want? Plus, get an extra £5 Gift Certificate when you trade in books worth £10 or more before June 30, 2012. Visit the Books Trade-In Store for more details. |
Product details |
More About the Author
Product Description
Product Description
Perl is a very powerful tool for Oracle database administrators, but too few DBAs realize how helpful Perl can be in managing, monitoring, and tuning Oracle databases. Whether you're responsible for Oracle9i, Oracle8i, or earlier databases, you'll find Perl an invaluable addition to your database administration arsenal.
You don't need to be a Perl expert to use the excellent applications and scripts described in Perl for Oracle DBAs. The book explains what you need to know about Perl, provides a wealth of ready-to-use scripts developed especially for Oracle DBAs, and suggests many resources for further exploration. The book covers:
- The Perl language -- an introduction to Perl, its rich history and culture, and its extensive text processing and data transformation capabilities.
- The Perl/Oracle architecture -- Detailed information about Perl DBI, DBD::Oracle, the Oracle Call Interface (OCI), Oracle::OCI, extproc_perl, and mod_perl, the modules that allow Perl programs to communicate with Oracle databases.
- Perl applications for Oracle DBAs -- Profiles of the best Perl open source applications available for use and customization by Oracle DBAs: Perl/Tk, OraExplain, StatsView, Orac, DDL::Oracle, SchemaDiff, Senora, DBD::Chart, SchemaView-Plus, Oracletool, Karma, Embperl, and Mason.
- The Perl Database Administration (PDBA) Toolkit -- a comprehensive suite of specialized, ready-to-use scripts designed to help Oracle DBAs perform both routine and special-purpose administrative tasks: monitoring the Oracle alert log and databases, creating and managing Oracle user accounts, maintaining indexes and extents, extracting DDL and data, troubleshooting and tuning database problems, and much more.
From the Publisher
If you've wanted to see what Perl can do for your development and database administration, this book will guide you step-by-step through the process. Perl for Oracle DBAs comes with a toolkit of more than 100 useful scripts that you can use to create databases and users, clone database DDL, maintain user data, compare schemas, monitor database performance, backup data, and perform many other tasks. Written by Oracle DBAs for Oracle DBAs, this book walks you through everything you need to know to put Perl to work for you right away.
Inside This Book
(Learn More)
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organise and find favourite items. |
Customer Reviews
Most Helpful Customer Reviews
1 of 1 people found the following review helpful
Format:Paperback
Over time, as we develop systems, cut code, administer data bases and perform myriad other
tasks, we tend to build up a 'kit bag' of useful tricks, code snippets and techniques.
This book makes a welcome contribution with its many printed examples and pointers.
tasks, we tend to build up a 'kit bag' of useful tricks, code snippets and techniques.
This book makes a welcome contribution with its many printed examples and pointers.
Although, as the title suggests, this is aimed primarily at Oracle administrators, there is much here
for those with more than a passing interest in the rich text-processing language that is Perl.
With library modules available for Sysbase and MySQL for example, connections are a simple matter of
appropriate API calls.
Indeed, in the excellent appendices, there is a code example showing simultaneous connections
to both an Oracle and a MySQL database and how to extract and process data between them
using some embedded SQL. The ability yo do this without resorting to dump and re-loads using ASCII
flat files was a small revelation.
With its clear real-world approach and incisive, and often witty, explanations and observations,
this book is not only a boon to data base administrators but can also be very useful
to those who simply want to learn more about the power of Perl.
Most Helpful Customer Reviews on Amazon.com (beta)
Amazon.com:
9 reviews
9 of 9 people found the following review helpful
Great book for DBAs wanting to take advantage of perl
2 Dec 2002
Format:Paperback
I've always loved perl and wrote a lot of utilities to monitor and manage databases when I worked as a full time DBA (using oraperl & perl4). However, over the years as my focus shifted to wider software architecture I found it difficult to keep up with new releases, modules and so forth. From time to time I would visit CPAN but the sheer volume of modules and the limited time I had was preventing me from taking full advantage of modern perl.
Jared and Andy's book neatly solved this problem. Within an hour of opening their book I had fully upgraded my perl and added heaps of fantastic utilities that I never even knew existed. Sometimes perl can be hard to install and configure but this book makes it a breeze.
This book is indispensable if you are trying to get started with perl - and every DBA should! If you are already a perl user I'm sure you'll learn about new features or find utilities that will repay the cost of the book many times over.
8 of 8 people found the following review helpful
AS FINE AS A PEARL COULD BE
12 Jan 2003
Format:Paperback
"Perl for Oracle DBAs" is indeed a real pearl. This 600-plus paged volume was designed to be a reliable friend of any administrator, whose responsibilities include the oiling of Oracle database machinery.
The book, which comes with a toolkit package that contains more than a hundred ready-to-use programs, bared all the mysteries that surround Oracle/Perl software: including Oracle Call Interface (OCI), Perl DataBase Interface (DBI), as well as all the other modules that commune with both software.
This book runs as smoothly as any pearl could run.
The book, which comes with a toolkit package that contains more than a hundred ready-to-use programs, bared all the mysteries that surround Oracle/Perl software: including Oracle Call Interface (OCI), Perl DataBase Interface (DBI), as well as all the other modules that commune with both software.
This book runs as smoothly as any pearl could run.
8 of 8 people found the following review helpful
Perl makes life easier
2 Oct 2002
Format:Paperback
Over time, as we develop systems, cut code, administer data bases and perform myriad other tasks, we tend to build up a 'kit bag' of useful tricks, code snippets and techniques.
This book makes a welcome contribution with its numerous code examples and clear explanations.
This book makes a welcome contribution with its numerous code examples and clear explanations.
Although, as the title suggests, this is aimed primarily at Oracle administrators, there is much here for those with more than a passing interest in the rich text-processing language that is Perl.
With library modules also available for Sysbase and MySQL, for example, connections across disparate databases are a simple matter of appropriate API calls.
Indeed, in the excellent appendices, there is a code example showing simultaneous connections to both an Oracle and a MySQL database and how to extract and process data between them
using Perl code and embedded SQL. The ability to do this easily and efficiently without resorting to dump and re-loads using ASCII flat files was a small revelation.
With their clear real-world approach, incisive and, often witty, explanations and observations, the enthusiasm of the authors for their subject is clear.
This book is not only a boon to data base administrators but should also prove to be very useful to those who simply want to learn more about the power of Perl.
Were these reviews helpful?
Let us know
Listmania!
Look for similar items by category
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
