Perl for Oracle DBAs Paperback – Aug 29 2002
|New from||Used from|
Customers Who Bought This Item Also Bought
No Kindle device required. Download one of the Free Kindle apps to start reading Kindle books on your smartphone, tablet, and computer.
To get the free app, enter your e-mail address or mobile phone number.
About the Author
Andy Duncan is the coauthor of Oracle & Open Source (O'Reilly, 2001), as well as Perl for Oracle DBAs (O'Reilly, 2002). The first book arose after Andy's creation, in 1998, of the Orac Perl/Tk tool for Oracle DBAs. Since then, he has worked mainly as an independent development and DBA consultant, and has counted both Oracle Corporation and Sun Microsystems among his long-term clients. In addition to performing Oracle, Perl, and Java consultancy work, Andy teaches as a senior instructor for Learning Tree International, covering both introductory and advanced Perl courses. He lives in Oxfordshire, England.
Jared Still has been an Oracle DBA in health insurance and manufacturing environments since 1994 (and version 7.0.13 of Oracle). He first began dabbling with Perl in 1993 and it was love at first sight. Perl became an integral part of his Oracle toolkit when it was used to rapidly prototype and implement complex reporting based on data in Oracle databases. Jared has been working with databases of various ilks since 1988, and along the way has also worked as a Unix system administrator. When not riding herd on the databases at the OK Corral, he likes to spend time tinkering on his car, fly fishing, or sitting on the deck in the backyard at his home doing absolutely nothing. He can be reached at firstname.lastname@example.org.
Inside This Book(Learn More)
Top Customer Reviews
If someone publish a book saying "UNIX Korn shell scripts for Oracle DBA's", what do I expect? Simply! learn about UNIX Korn shell and how to write DBA scripts for my Oracle system. But if the book talks about utilities written for Oracle in Korn shell scripts, then, clearly it fails its purpose.
Maybe those tools described can be useful for DBA tasks, specially because they're free... the bottom line is that this book doesn't teach you how to programm in Perl. Get something else, devoted just to Perl programming, like "Perl 6 Essentials" from Allison Randal.
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.
Experienced Oracle DBAs with a Perl bent should feel free to skip straight to Part II, Extending Perl. Here the authors provide information on Perl GUI and Web extensions, plus some Open Source tools for Oracle that make use of these features. They also discuss a feature I really like: the ability to call Perl routines from PL/SQL, but as the authors point out, you should be aware of the security implications.
To my mind, Part III: The PDBA Toolkit is the most valuable part of the book. The authors have kindly provided a set of superb Perl tools for the Oracle DBA. Everyone will have their favourites, but mine include the ability to monitor alert logs in real time and a password client/server combo for centralised, encrypted management over the network. Last but not least: the ability to monitor SQL and store explain plans for historical comparison over time.
This book is a like a Tardis - its much bigger on the inside than it looks on the outside. The volume of information could have been overwhelming, but the authors have taken the time to patiently explain the topics from first principles without ever patronising the reader. That's a rare skill, and this is a fantastic book.
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.
Most recent customer reviews
These authors have taken two somewhat diverse topics and combined them into an easy-to-read and cohesive book. Read morePublished on June 1 2004 by Donald Burleson
"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... Read morePublished on Jan. 12 2003 by reviewer
The book is clear, concise and to the point. Style is excellent as I would expect from Andy and Jared. Read morePublished on Nov. 6 2002 by Mladen Gogala
As an Oracle DBA the only problem I've found with Perl is that there is so much other information out there that it is difficult to find what you need. Read morePublished on Sept. 12 2002
Look for similar items by category
- Books > Computers & Technology > Databases > Database Management Systems
- Books > Computers & Technology > Databases > Oracle > DBA
- Books > Computers & Technology > Programming > Languages & Tools
- Books > Computers & Technology > Software
- Books > Professional & Technical > Professional Science > Mathematics
- Books > Textbooks > Computer Science & Information Systems > Computer Science
- Books > Textbooks > Computer Science & Information Systems > Database Storage & Design
- Books > Textbooks > Computer Science & Information Systems > Programming Languages