Download or read book Perl for Oracle DBAs written by Andy Duncan and published by "O'Reilly Media, Inc.". This book was released on 2002 with total page 620 pages. Available in PDF, EPUB and Kindle. Book excerpt: This handbook describes what DBAs need to know about Perl and explains how they can use this popular open source language to manage, monitor, and tune their databases.
Download or read book Perl for Oracle DBAs written by Andy Duncan and published by "O'Reilly Media, Inc.". This book was released on 2002-08-19 with total page 624 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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. The book also explains how Oracle DBAs and developers can extend the toolkit and solve their own database administration problems using Perl.
Download or read book Programming the Perl DBI written by Tim Bunce and published by "O'Reilly Media, Inc.". This book was released on 2000-02-04 with total page 372 pages. Available in PDF, EPUB and Kindle. Book excerpt: One of the greatest strengths of the Perl programming language is its ability to manipulate large amounts of data. Database programming is therefore a natural fit for Perl, not only for business applications but also for CGI-based web and intranet applications.The primary interface for database programming in Perl is DBI. DBI is a database-independent package that provides a consistent set of routines regardless of what database product you use--Oracle, Sybase, Ingres, Informix, you name it. The design of DBI is to separate the actual database drivers (DBDs) from the programmer's API, so any DBI program can work with any database, or even with multiple databases by different vendors simultaneously.Programming the Perl DBI is coauthored by Alligator Descartes, one of the most active members of the DBI community, and by Tim Bunce, the inventor of DBI. For the uninitiated, the book explains the architecture of DBI and shows you how to write DBI-based programs. For the experienced DBI dabbler, this book reveals DBI's nuances and the peculiarities of each individual DBD.The book includes: An introduction to DBI and its design How to construct queries and bind parameters Working with database, driver, and statement handles Debugging techniques Coverage of each existing DBD A complete reference to DBI This is the definitive book for database programming in Perl.
Download or read book Linux Recipes for Oracle DBAs written by Darl Kuhn and published by Apress. This book was released on 2008-11-21 with total page 521 pages. Available in PDF, EPUB and Kindle. Book excerpt: Linux Recipes for Oracle DBAs is an example–based book on managing Oracle Database in a Linux environment. Covering commonly used distributions such as Red Hat Enterprise Linux and Oracle Enterprise Linux, the book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of Linux documentation. The book is task–oriented: Look up the task to perform. See the solution. Read up on the details. Get the job done. Takes you directly from problem to solution Covers the “right” mix of Linux user and administration tasks for database administrators Respects your time by being succinct and to–the–point What you’ll learn Execute Linux commands applicable to Oracle Database administration. Write shell scripts to automate critical DBA tasks. Monitor, tune, and optimize a Linux server to run Oracle Database. Perform Linux system administration tasks relevant to Oracle Database. Implement Oracle real application clusters on Linux. Implement Oracle automatic storage management on Linux. Remotely (and securely!) manage Oracle on Linux. Who this book is for Linux Recipes for Oracle DBAs is a book for Oracle database administrators who want to expertly operate Oracle databases on the Linux operating system. If you’re new to Linux, or are migrating from a Unix platform, or just want detailed solutions for tasks that Oracle DBAs perform on Linux servers, this book is for you.
Download or read book Oracle PL SQL Programming written by Steven Feuerstein and published by "O'Reilly Media, Inc.". This book was released on 2005-08-22 with total page 1198 pages. Available in PDF, EPUB and Kindle. Book excerpt: The latest edition of this classic reference has been updated to cover Oracle Database 10g. Among the Oracle 10g features examined include regular expression support, native compilation, and new datatypes. The book also includes discussions on language syntax, how to build real applications, and how to apply best practices. Written by the world's foremost PL/SQL authority, Steven Feuerstein.
Download or read book Oracle and Open Source written by Andy Duncan and published by O'Reilly Media. This book was released on 2001-04 with total page 442 pages. Available in PDF, EPUB and Kindle. Book excerpt: The first book to tie together the commercial world of Oracle and the free-wheeling world of open source software, this guide describes nearly 100 open source tools, from the wide applied (Linux, Apache) to the Oracle-specific (Orasoft, Orac). Readers learn where to get them, their advantages to Oracle developers and DBAs, and how to create and release new open source Oracle tools.
Download or read book Advanced Perl Programming written by Sriram Srinivasan and published by "O'Reilly Media, Inc.". This book was released on 1997 with total page 444 pages. Available in PDF, EPUB and Kindle. Book excerpt: Covers advanced features of Perl, how the Perl interpreter works, and presents areas of modern computing technology such as networking, user interfaces, persistence, and code generation.
Download or read book High Performance Oracle written by Geoff Ingram and published by John Wiley & Sons. This book was released on 2002-10-15 with total page 720 pages. Available in PDF, EPUB and Kindle. Book excerpt: "Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues." -Aki Ratner, President, Precise Software Solutions Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"-- that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system--not just the database. High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system. The book provides practical solutions for: * Choosing physical layout for ease of administration and efficient use of space * Managing indexes, including detecting unused indexes and automating rebuilds * SQL and system tuning using the powerful new features in Oracle9i Release 2 * Improving SQL performance without modifying code * Running Oracle Real Application Clusters (RAC) for performance and availability * Protecting data using Recover Manager (RMAN), and physical and logical standby databases The companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.
Download or read book DBAs Guide to Databases Under Linux written by Syngress and published by Elsevier. This book was released on 2000-04-26 with total page 485 pages. Available in PDF, EPUB and Kindle. Book excerpt: In an effort to increase its marketshare and threat to Windows NT, Oracle8 was ported to Linux in late 1998, opening the popular database to an additional 10 million Linux users worldwide. The availability of Oracle8 enables current Linux users to deploy enterprise-class applications at low cost and provides an alternative to Microsoft Windows NT. This book covers that marriage of the most popular database and the fastest growing operating system. * Complete coverage. Covers both Oracle8i and Oracle8i Lite, as well as Oracle Applications, Oracle Applications Server, and Oracle Developer * Organizations and Oracle database administrators will be looking for information on Linux as is gets adopted - this book fits the bill * Covers two growth markets and fills a need for information not covered elsewhere
Download or read book Oracle DBA Automation Quick Reference written by Charlie Russel and published by Prentice Hall Professional. This book was released on 2004 with total page 296 pages. Available in PDF, EPUB and Kindle. Book excerpt: With concise coverage of both Oracle 9i and Oracle 10g, this is the ideal reference for the professional DBA on how to use Perl to automate database tasks. The book covers language selection and concepts, including basic scripting concepts.
Download or read book Oracle RMAN Pocket Reference written by Darl Kuhn and published by O'Reilly Media. This book was released on 2001-11-08 with total page 128 pages. Available in PDF, EPUB and Kindle. Book excerpt: Oracle RMAN Pocket Reference is a handy guide for DBAs who intend to use Oracle Recovery Manager for database backup and recovery. Because Recovery Manager (RMAN) is a relatively new tool, many DBAs are just becoming familiar with it. They will welcome a timely book that explains clearly and concisely how to use RMAN for common backup and recovery tasks that are infrequent, yet extremely vital. The first portion of the book is primarily task-oriented. After a short section on RMAN architecture, the book shows (in checklist style) how to perform common backup and recovery tasks such as: Implementing a recovery catalog Creating and running RMAN scripts Configuring input/output channels Taking a full database backup Backing up tablespaces and datafiles Taking incremental backups Recovering lost datafiles The second portion of the book consists of a handy syntax reference to the many RMAN commands. Having a quick reference to RMAN commands is a great convenience to DBAs who otherwise, often under the pressure of a recovery situation, would have to wade through Oracle's online documentation.
Download or read book Perl Database Programming written by Brent Michalski and published by Wiley. This book was released on 2002-11-07 with total page 580 pages. Available in PDF, EPUB and Kindle. Book excerpt: Author is an experienced Perl user who maintains the Perl area of Dr. Dobb's Journal Website. * The first book to cover the full range of Perl database programming topics. * Discusses practical applications such as online catalogs, Web-based photo databases, and Palm-powered applications.
Download or read book Computerworld written by and published by . This book was released on 2004-06-07 with total page 60 pages. Available in PDF, EPUB and Kindle. Book excerpt: For more than 40 years, Computerworld has been the leading source of technology news and information for IT influencers worldwide. Computerworld's award-winning Web site (Computerworld.com), twice-monthly publication, focused conference series and custom research form the hub of the world's largest global IT media network.
Download or read book Perl for System Administration written by David N. Blank-Edelman and published by "O'Reilly Media, Inc.". This book was released on 2000 with total page 452 pages. Available in PDF, EPUB and Kindle. Book excerpt: Some people plan to become administrators. The rest of us are thrust into it: we are webmasters, hobbyists, or just the default "technical people" on staff who are expected to keep things running. After some stumbling around repeating the same steps over and over again (and occasionally paying the price when we forget one), we realize that we must automate these tasks, or suffer endless frustration. Thus enters Perl.The Perl programming language is ideal for writing quick yet powerful scripts that automate many administrative tasks. It's modular, it's powerful, and it's perfect for managing systems and services on many platforms.Perl for System Administration is designed for all levels of administrators--from hobbyists to card-carrying SAGE members--sysadmins on multi-platform sites. Written for several different platforms (Unix, Windows NT, and Mac OS), it's a guide to the pockets of administration where Perl can be most useful for sites large and small, including: Filesystem management User administration with a dash of XML DNS and other network name services Database administration using DBI and ODBC Directory services and frameworks like LDAP and ADSI Using email for system administration Working with log files of all kinds Each chapter concentrates on a single administrative area, discusses the possible pitfalls, and then shows how Perl comes to the rescue. Along the way we encounter interesting Perl features and tricks, with many extended examples and complete programs. The scripts included in the book can simply be used as written or with minimal adaptation. But it's likely that readers will also get a taste of what Perl can do, and start extending those scripts for tasks that we haven't dreamed of.Perl for System Adminstration doesn't attempt to teach the Perl language, but it is an excellent introduction to the power and flexibility of Perl, and it whets the appetite to learn more. It's for anyone who needs to use Perl for system administration and needs to hit the ground running.
Download or read book Real World SQL Server Administration with Perl written by Linchi Shea and published by . This book was released on 2003-07-24 with total page 836 pages. Available in PDF, EPUB and Kindle. Book excerpt: "SQL Server Administration with Perl" consists of a series of scenarios covering a wide range of SQL Server administrative topics. These are real-world scenarios that you hear DBAs discussing on the SQL Server forums and newsgroups-scenarios that DBAs run into in their day-to-day development or production environments. Readers will walk away from this book with two things: a DBA toolkit with well over 150 Perl scripts and problem-solving techniques they can apply to create even more tools for attacking other SQL Server administrative problems.
Download or read book Easy Oracle PHP written by Mladen Gogala and published by Rampant TechPress. This book was released on 2006 with total page 272 pages. Available in PDF, EPUB and Kindle. Book excerpt: This unique book focuses on removing the guesswork from creating dynamic web pages with Oracle content. Packed with working code examples, this book shows working examples of connecting to Oracle and delivering data into an HTML page. This indispensable reference shows working examples of complex Oracle queries in PHP, updating Oracle from PHP, and passing parameters to a PHP program.
Download or read book Oracle Regular Expressions Pocket Reference written by Jonathan Gennick and published by "O'Reilly Media, Inc.". This book was released on 2003-09-05 with total page 67 pages. Available in PDF, EPUB and Kindle. Book excerpt: Support for regular expressions in SQL and PL/SQL is one of the most exciting features of Oracle Database 10G. Oracle has long supported the ANSI-standard LIKE predicate for rudimentary pattern matching, but regular expressions take pattern matching to a new level. They provide a powerful way to select data that matches a pattern, as well as to manipulate, rearrange, and change that data.This concise pocket guide is part tutorial and part quick-reference. It's suitable for those who have never used regular expressions before, as well as those who have experience with Perl and other languages supporting regular expressions. The book describes Oracle Database 10G's support for regular expressions, including globalization support and differences between Perl's syntax and the POSIX syntax supported by Oracle 10G. It also provides a comprehensive reference, including examples, to all supported regular expression operators, functions, and error messages.O'Reilly's Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. Whether you're using regular expressions for the first time or applying your skills from other languages to the latest version of Oracle, the Oracle Regular Expressions Pocket Reference is the book to have close by.
