Perl for Oracle DBAs

Product Description
Perl is a wonderfully powerful and efficient tool for database administrators. It can be used to manage, monitor and tune your Oracle database. But the challenge for most Oracle DBAs is that, in spite of the benefits of using Perl, they have neither the time nor the resources to become Perl experts. Fortunately, you don’t need to be a Perl expert to use Perl scripts. Perl for Oracle DBAs includes everything you’ll need to get started using this popular open source language to manage your database, from an introduction to Perl to a wealth of ready-to-use DBA scripts. 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.

Perl for Oracle DBAs


5 Responses to “Perl for Oracle DBAs”

  • This is NOT a book for learning Perl if you’re a DBA. The whole book is devoted to describe a lot of free DBA utilities written in this language, and it doesn’t give you any roboust help to build your own Oracle-Perl scripts. There’s a very little (about 40 pages) APPENDIX devoted to look at the language grammar and programming issues. The only chapter that deserve the only star I give for this book is CHP7 – OCI Calls with Oracle::OCI. But, is this a book written for DBA’s or developers?
    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.
    Rating: 1 / 5

  • These authors have taken two somewhat diverse topics and combined them into an easy-to-read and cohesive book.

    The examples are especially helpful and the authors take great care to explain the issues in Plain English.

    Overall, a highly recommended book.
    Rating: 5 / 5

  • Perl is the ideal language for Oracle DBAs. Those who are already aware of its strengths will have implemented it to some degree on their servers. For DBAs who may have heard rumours of its magic, then Part I of Andy Duncan and Jared Still’s “Perl for Oracle DBAs” will prove to be a substantial grounding in the synergy that can arise between Oracle and Perl’s virtues of Laziness, Impatience and Hubris. This section provides information on Perl’s background, its strengths and provides instructions for installing the language on UNIX, Win32 and Cygwin. (For those not in the know: Cygwin is a free UNIX emulation layer for Windows that includes a substantial collection of GNU tools). Perl is the ideal language for DBAs in a heterogeneous environment.

    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.
    Rating: 5 / 5

  • 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. This book is ideal in that someone else has done all the hard work so there is now one definitve resource for Perl for DBA’s and about time too. I’ve found all Oracle O’Reilly books exceptional and this one carries on the trend.
    Rating: 5 / 5

  • The best word to describe this book is ‘WOW!’ I had no idea that there was such an extensive set of perl tools and scripts for administering oracle databases. The book provides descriptions of the tools/scripts, instructions for download/installation and operational information. I can’t wait to dive in and explore each of the topics in depth (should take me a year or so…).
    Rating: 5 / 5

Leave a Reply

You must be logged in to post a comment.




We will keep You Updated...
Sign up to receive breaking news
as well as receive other site updates!

Enter your email address below
to receive new posts in your mailbox:

Delivered by FeedBurner

Sponsors
urlsubmitsadvertise heremobiles22
topmedicalgaariwatches
Featured Search
 
Author:
Title:
Publisher:
Keywords:
(Searches all fields)

Price: (£) min to max
Edition: 1st Edition  Signed
 
Popular Posts

Wong's Nursing Care of Infants and Children (Wongs Nursing Care of Infants and Children)

Wong's Nursing Care of Infants and Children (Wongs Nursing Care of Infants and Children) Long relied on as the industry's most comprehensive, authoritative source fo

A Short Account of the Destruction of the Indies

A Short Account of the Destruction of the Indies "A Short Account of the Destruction of the Indies," published in 1552 by the Spanish Dominican priest Bartolomé de

Beauty and the Beast: Beauty and the Beast A TALE FOR THE ENTERTAINMENT OF JUVENILE READERS

Beauty and the Beast: Beauty and the Beast A TALE FOR THE ENTERTAINMENT OF JUVENILE READERS Beauty and the Beast By Marie Le Prince de Beaumont BEAUTY AND THE BE

Major Account Sales Strategy

Major Account Sales Strategy ISBN13: 9780070511149Condition: NewNotes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compare our books, pric

Baby Bargains: Secrets to Saving 20% to 50% on Baby Furniture, Equipment, Clothes, Toys, Maternity Wear and Much, Much More!

Baby Bargains: Secrets to Saving 20% to 50% on Baby Furniture, Equipment, Clothes, Toys, Maternity Wear and Much, Much More! ISBN13: 9781889392332Condition: NewNotes:

Statistics for Business and Economics (with Bind-In Printed Access Card) Reviews

Statistics for Business and Economics (with Bind-In Printed Access Card) Discover how you can use statistical results to solve contemporary business problems when yo

Fashion: From Concept to Consumer (9th Edition)

Fashion: From Concept to Consumer (9th Edition) An invaluable tool for anyone who wants to know more about fashion and the fashion business, retail store buyers and

The Grand Design

The Grand Design THE FIRST MAJOR WORK IN NEARLY A DECADE BY ONE OF THE WORLD’S GREAT THINKERS—A MARVELOUSLY CONCISE BOOK WITH NEW ANSWERS TO THE ULTIMATE QUESTIO

Rules for Aging: A Wry and Witty Guide to Life

Rules for Aging: A Wry and Witty Guide to Life ISBN13: 9780156013604Condition: NewNotes: BUY WITH CONFIDENCE, Over one million books sold! 98% Positive feedback. Compa

Materials Science and Engineering: An Introduction

Materials Science and Engineering: An Introduction Building on the success of previous editions, this book continues to provide engineers with a strong understanding
Categories
Featured Products
  • Millionaire Forex Trader Reveals Secret Method.: As Seen In The Best-selling Book 'Millionaire Traders' - Professional Forex Trader And Private Fund Manager Ashkan Bolour Now Offers His Forex Trading Method. This Is An Automated Trading System That Collects Profits While You Sleep.
  • The Oil Trading Business.: Forget Forex - The Real Professionals Trade Oil Because It Is Easier And More Profitable. Completely Genuine Website Run By A Full Time Oil Trader. E-Book Guides And Software Indicators For MetaTrader. Great To Promote To All Those Failed Forex Traders!
  • HardStyle Golf Conditioning.: Improve Power, Strength, Balance And Flexibility With One Kettlebell. HardStyle Golf Is The First Book That Combines The 4 Phases Of Golf Conditioning With The Power Techniques Of Russian Kettlebell Training.
  • Autism, Aspergers, Asd - Help And Advice For Parents.: Affiliates Earn 75% Commission - Http://autism-aspergers-asd.com/Affiliates.html Package Has 4 Books Called 'Rules Of The Game' Plus 3 Bonus Workbooks. Author Is Academically Qualified With 13 Years Experience As Both A Mother And A Consultant To Parents.
  • Weight Loss Transformation - Audio Coaching Program!!!: Pays 75% & Converts Big ::: Proven Sales Copy & Personalized Solo Blasts Written By Top Copywriter For Affs ::: Brandable/Reprintable Articles, Audios, Videos & E-books.
Facebook Like
Follow us
A Post on this Blog

Hire Me Direct

Recent Posts

The Best American Noir of the Century

Product Description In his introduction to the The Best American Noir of the Century, James Ellroy... 

No Good Deed: Book One of the Mark Taylor Series (A Psychological Thriller)

No Good Deed: Book One of the Mark Taylor Series (A Psychological Thriller) Mark Taylor discovers first... 

The Jungle Book

Product DescriptionIf you love a good story, then look no further. Oxford Children’s Classics... 

Kurt Vonnegut and the American Novel

Kurt Vonnegut and the American Novel The novels of Kurt Vonnegut depict a profoundly absurd and distinctly... 

Memoirs of Halide Edib

Memoirs of Halide Edib A prominent novelist, social activist, journalist, and nationalist, Halide Adivar... 

Recent Comments
51 of 55 people found the following review helpful: Disturbing in its Relevance,
63 of 66 people found the following review helpful: From "Red Adept Reviews", Ja
244 of 258 people found the following review helpful: Wonderful Book!, October 1
Until I read your article, I thought I was well versed on this subject matter. Thank you for giving me more fresh information to ad
I agree with a lot of the points in this article. Your passion for this subject and the way you describe it is very well planned. T
Tag Cloud