Oracle Scripts
Author: Brian Lomasky
Publisher: "O'Reilly Media, Inc."
Published: 1998-05
Total Pages: 214
ISBN-13: 9781565924383
DOWNLOAD EBOOKProvides a set of tools for Orcale database administrators and developers.
Posts
Oracle Tuning Power Scripts
Author: Harry Conway
Publisher: Rampant TechPress
Published: 2005
Total Pages: 480
ISBN-13: 0974448672
DOWNLOAD EBOOKTargeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.
All-In-one Oracle DBA Scripts
Author: Arun Kumar
Publisher:
Published: 2019-09-05
Total Pages: 194
ISBN-13: 9781691114948
DOWNLOAD EBOOKThis eBook is a collection of my real-time DBA scripts that I use in daily database administration. You can simply copy paste these scripts and start using them immediately on any Oracle database.SCRIPTS INCLUDED INSIDE: =====================- ASM Scripts- Auditing Scripts- CRSCTL & RAC Scripts- Database Info Scripts- Dataguard Monitoring Scripts- Database Monitoring Scripts- EXPDP / IMPDP Scripts- Flashback Scripts- Multitenant Scripts- Network Management Scripts- Object Management Scripts- OEM / Cloud Control Scripts- Partitioning Scripts- RMAN Scripts- Scheduler & Jobs- SRVCTL Scripts- Tablespace and User management scriptsDISCLAIMER: please execute all the scripts on a test server before executing on a production server. The scripts are for your reference purpose only and hope that it may be of use, but is not guaranteed to be correct, up to date or suitable for any particular purpose.
Perl for Oracle DBAs
Author: Andy Duncan
Publisher: "O'Reilly Media, Inc."
Published: 2002-08-19
Total Pages: 624
ISBN-13: 1449390919
DOWNLOAD EBOOKPerl 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.
Oracle DBA Automation Scripts
Author: Rajendra Gutta
Publisher: Sams Publishing
Published: 2002
Total Pages: 0
ISBN-13: 9780672322686
DOWNLOAD EBOOK"Oracle DBA Automation Scripts" provides valuable, time-tested scripts for any DBA to automate the daily administration activity of an Oracle database. It provides scripts for space management, Backup and recovery, tuning, and other handy scripts (locking, user reports, resource usage etc.), useful for troubleshooting everyday problems. The book highlights the need to identify and fix potential problems before they can cause loss of data.
Mike Ault's Oracle Internals Monitoring and Tuning Scripts
Author: Mike Ault
Publisher: Rampant TechPress
Published: 2003-12
Total Pages: 372
ISBN-13: 9780972751384
DOWNLOAD EBOOKA guide to Oracle DBA management scripts, this book is indispensable for all Oracle professionals who must quickly automate and manage their Oracle databases with scripts. An online code depot full of more than 200 pretested Oracle DBA scripts is provided. Coverage of all areas of Oracle database administration including data files, tablespace, and table and index management scripts is included. Also reviewed are mechanisms for automating Oracle database administration tasks and tips for automating without buying expensive tools.
Oracle DBA on Unix and Linux
Author: Michael Wessler
Publisher: Sams Publishing
Published: 2002
Total Pages: 604
ISBN-13: 9780672321580
DOWNLOAD EBOOKMaintain a robust, mission-critical Oracle8i database. This book provides administrative solutions for the day-to-day DBA. You'll learn how to install the database for maximum efficiency, upgrades, patches, migrations, tune, and maintain its security. The book also explains in detail how to build and support a fully functioning Oracle database. This authoritative text contains up-to-date information available on Oracle's latest release and shows you how to: configure database architecture; install and set up with UNIX requirements; create the actual database with scripts; GUI management produc.
Unix for Oracle DBAs Pocket Reference
Author: Donald K. Burleson
Publisher: "O'Reilly Media, Inc."
Published: 2001-02
Total Pages: 110
ISBN-13: 0596529090
DOWNLOAD EBOOKThe Unix for Oracle DBAs Pocket Reference puts within easy reach the commands that Oracle database administrators need most when operating in a Unix environment. If you are an Oracle DBA moving to Unix from another environment such as Windows NT or IBM Mainframe, you know that these commands are far different from those covered in most beginning Unix books. To jump start your learning process, Don Burleson has gathered together in this succinct book the Unix commands he most often uses when managing Oracle databases. You'll be able to reach into your pocket for the answer when you need to know how to: Display all Unix components related to Oracle, identify the top CPU consumers on your server, and even kill processes when necessary Stack Unix commands into powerful scripts that can perform vital DBA functions Monitor Unix filesystems, and automatically manage your trace files, dump files, and archived redo log files Use essential server monitoring commands such as top, sar, and vmstat And there's much more between these covers. If you need to get up to speed with Oracle on Unix, and quickly, this book is for you.
Oracle Core: Essential Internals for DBAs and Developers
Author: Jonathan Lewis
Publisher: Apress
Published: 2012-01-29
Total Pages: 276
ISBN-13: 1430239557
DOWNLOAD EBOOKOracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting—no more, no less. Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data. Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book. Provides proven content from a world-renowned performance and troubleshooting expert Emphasizes the significance of internals knowledge to rapid identification of database performance problems Covers the core essentials and does not waste your time with esoterica
Oracle DBA Tips & Techniques
Author: Sumit Sarin
Publisher: Tips & Techniques
Published: 2000
Total Pages: 0
ISBN-13: 9780072122459
DOWNLOAD EBOOKKnowledge of "insider" tips on administering Oracle databases can mean the difference between a secure, smoothly running database and a corporate disaster. This book provides high-end administrative solutions for the day-to-day DBA by leveraging relatively unexplored Oracle features with methods that have proven merit in practical situations.
