Everyday Oracle DBA
Everyday Oracle DBA

Author: April Wells

Publisher: McGraw-Hill Osborne Media

Published: 2006

Total Pages: 372

ISBN-13:

DOWNLOAD EBOOK

Hundreds of Ways to Get More Done Faster Learn how to effectively and efficiently administer an Oracle database and handle a variety of daily tasks with ease. Filled with tips, tricks, and shortcuts, Everyday Oracle DBA is designed to make your job easier and more productive. The book covers database setup, user management, PL/SQL, backup, restoration, tuning, troubleshooting, testing, and much more. Get the answers you need right at your fingertips from this Oracle Press guide. Allow user access while protecting data integrity Enable automated database auditing Use PL/SQL stored program units for administrative tasks Set up and implement a sound backup and recovery plan Handle disaster recovery Monitor and tune the database for peak performance Enable high availability using Oracle Real Application Clusters (RAC), Data Guard, and other tools Take advantage of Oracle Enterprise Manager, Oracle Application Manager, and other built-in utilities

All-In-one Oracle DBA Scripts
All-In-one Oracle DBA Scripts

Author: Arun Kumar

Publisher:

Published: 2019-09-05

Total Pages: 194

ISBN-13: 9781691114948

DOWNLOAD EBOOK

This 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.

Expert One-on-One Oracle
Expert One-on-One Oracle

Author: Thomas Kyte

Publisher: Apress

Published: 2010-11-16

Total Pages: 1328

ISBN-13: 9781430212799

DOWNLOAD EBOOK

* A proven best-seller by the most recognized Oracle expert in the world. * The best Oracle book ever written. It defines what Oracle really is, and why it is so powerful. * Inspired by the thousands of questions Tom has answered on his http://asktom.oracle.com site. It tackles the problems that developers and DBAs struggle with every day. * Provides everything you need to know to program correctly with the database and exploit its feature-set effectively.

Oracle DBA on Unix and Linux
Oracle DBA on Unix and Linux

Author: Michael Wessler

Publisher: Sams Publishing

Published: 2002

Total Pages: 604

ISBN-13: 9780672321580

DOWNLOAD EBOOK

Maintain 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.

Oracle Database Administration: The Essential Refe
Oracle Database Administration: The Essential Refe

Author: David Kreines

Publisher: O'Reilly Media, Incorporated

Published: 1999-04-14

Total Pages: 586

ISBN-13: 9781565925168

DOWNLOAD EBOOK

Oracle database administration requires a vast amount of information and an ability to perform a myriad of tasks--from installation to tuning to network troubleshooting to overall daily administration. Oracle provides many tools for performing these tasks; the trick is knowing what tool is right for the job, what commands you need to issue (and when), and what parameters and privileges you need to set. And, as every DBA knows, you need to know how do all this under pressure, while you face crisis after crisis. This book provides a concise reference to the enormous store of information an Oracle DBA needs every day (as well as what's needed only when disaster strikes). It's crammed full of quick-reference tables, task lists, and other summary material that both novice and expert DBAs will use time and time again. It covers the commands and operations new to Oracle8, but also provides Oracle7 information for sites still running earlier versions. Oracle Database Administration provides two types of material: DBA tasks--chapters summarizing how to perform critical DBA functions: installation, performance tuning, preventing data loss, networking, security and monitoring, auditing, query optimization, and the use of various Oracle tools and utilities DBA reference--chapters providing a quick reference to the Oracle instance and database, the initialization (INIT.ORA) parameters, the SQL statements commonly used by DBAs, the data dictionary tables, the system privileges and roles, and the SQL*Plus, Export, Import, and SQL*Loader syntax The book also includes a resource summary with references to additional books, Web sites, and other online and offline resources of special use to Oracle DBAs. Oracle Database Administration is the single essential reference you'll turn to again and again. If you must choose only one book to use at the office, keep at home, or carry to a site you're troubleshooting, this will be that book.

Oracle DBA SQL Quick Reference
Oracle DBA SQL Quick Reference

Author: Charlie Russel

Publisher: Prentice Hall Professional

Published: 2003

Total Pages: 566

ISBN-13: 9780131403031

DOWNLOAD EBOOK

Covering the core of the day-to-day tasks most DBA's are responsible for, this is the perfect complement to all SQL tutorials available. The book also provides syntax diagrams and SQL commands in alphabetical order.

Oracle DBA Automation Scripts
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.

Oracle Core: Essential Internals for DBAs and Developers
Oracle Core: Essential Internals for DBAs and Developers

Author: Jonathan Lewis

Publisher: Apress

Published: 2012-01-29

Total Pages: 276

ISBN-13: 1430239557

DOWNLOAD EBOOK

Oracle 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 Database 12c DBA Handbook
Oracle Database 12c DBA Handbook

Author: Bob Bryla

Publisher: McGraw Hill Professional

Published: 2015-07-03

Total Pages: 745

ISBN-13: 007179879X

DOWNLOAD EBOOK

The definitive reference for every Oracle DBA—completely updated for Oracle Database 12c Oracle Database 12c DBA Handbook is the quintessential tool for the DBA with an emphasis on the big picture—enabling administrators to achieve effective and efficient database management. Fully revised to cover every new feature and utility, this Oracle Press guide shows how to harness cloud capability, perform a new installation, upgrade from previous versions, configure hardware and software, handle backup and recovery, and provide failover capability. The newly revised material features high-level and practical content on cloud integration, storage management, performance tuning, information management, and the latest on a completely revised security program. Shows how to administer a scalable, flexible Oracle enterprise database Includes new chapters on cloud integration, new security capabilities, and other cutting-edge features All code and examples available online