A reference for RAC and TAF technology, this book demonstrates how to optimize Oracle clustered server environments for optimal performance and flexibility. Covering all areas of RAC continuous availability and transparent application failover, this book is indispensable for Oracle DBAs who are responsible for configuring and implementing RAC clusters databases. The secrets for successful design of RAC clusters and the expert internals of shared disk technology, raw devices, and RAID with RAC are described. The internal concurrency and PCM locking mechanisms within RAC are exposed, and the configuration of Transparent Application Failover is explained. Also provided are tips for monitoring and tuning RAC applications and tricks for using Oracle9i RAC Cluster Guard.

Oracle9i RAC: Oracle Real Application Clusters Configuration and Internals (Oracle In-Focus)

Computers & Technology

Ault, Michael R.

Tumma, Madhu

Software

Rampant TechPress

IT managers will be able to quickly assess the technical ability of any Oracle job candidate using these Oracle job interview questions that are not available to the general public. The personality and background characteristics of successful Oracle professionals are listed, and tips for identifying candidates with the right demeanor are presented. Also provided are methods for evaluating academic and work history and oral interview questions for Oracle database administrators, developers, and Oracle analysts. Techniques for quickly scanning resumes for pertinent information are also given.

Conducting the Oracle Job Interview: It Manager's Guide for Oracle Job Interviews With Oracle Interview Questions (Oracle In-Focus)

Burleson, Donald K.

Databases & Big Data

The dynamic memory features of Oracle9i make it possible to create a self-tuning database. This book explores proven techniques for monitoring the behavior of the Oracle System Global Area (SGA) and provides ways to anticipate upcoming problems and adjust the SGA before a performance problem occurs. Written for senior Oracle database administrators, this guide focuses on proactive tuning and scripting and shows how to collect historical data and use it to develop signatures for all memory areas. Provided are the commands to modify the Oracle9i SGA areas, sample scripts for automating SGA tuning, and access to an online code deport full of interesting Oracle scripts.

Creating a Self-Tuning Oracle Database: Automating Oracle9I Dynamic Sga Performance (Oracle In-Focus)

With the advent of inexpensive and fast worldwide connectivity, many Oracle professionals recognize the benefits of distributing Oracle data; however, Oracle multi-master replication is extremely complex and time-consuming to implement. This book addresses the complexity of Oracle replication by providing working code examples and illustrations of working systems. Demonstrated is every aspect of Oracle snapshot replication, including syntax for refresh intervals, managing snapshot logs, monitoring oracle replication, and refresh timings. Also detailed are techniques for implementing conflict resolution in multi-master replication.

Oracle Replication: Expert Methods for Robust Data Sharing (Oracle In-Focus series)

Garmany, John

Freeman, Robert G.

A reference for any Oracle database administrators who must ensure the consistency of data across distributed platforms, this book is for those administrators who recognize the benefits of distributing Oracle data. The intricacies of Oracle multi-master replication are described, and working code examples of complex multi-master replication are provided. Also included is information on Oracle replication tuning and monitoring.

Oracle Performance Troubleshooting: With Dictionary Internals, SQL & Tuning Scripts (Oracle In-Focus)

Robin Schumacher

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

Easy Oracle SQL: Get Started with Fast Writing SQL Reports With SQL*Plus

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

Mike Ault's Oracle Internals Monitoring and Tuning Scripts: Advanced Internals & OCP Certification Insights for the Master DBA (Oracle In-Focus)

Certification

Sharing secrets for the effective creation of auditing mechanisms for Health/Insurance Portability and Accountability Act of 1996 (HIPAA) compliant Oracle systems, this book demonstrates how the HIPAA framework provides complete security access and auditing for Oracle database information. Complete details for using Oracle auditing features, including auditing from Oracle redo logs, using system-level triggers, and using Oracle9i fine-grained auditing (FGA) for auditing of the retrieval of sensitive information, are provided. Examples from all areas of auditing are covered and include working scripts and code snippets. Also discussed are the use of the Oracle9i LogMiner to retrieve audits of database updates and how to implement all Oracle system-level triggers for auditing, including DDL triggers, server error triggers, and login and logoff triggers.

Oracle Privacy Security Auditing: Includes Federal Law Compliance With Hipaa, Sarbanes Oxley and the Gramm Leach Bliley Act Glb (Oracle In-Focus)

Nanda, Arup

For those database administrators intending to upgrade or those who need to know the new features that will affect the entire Oracle database world, this book relates all of the features of this new database. The complete details of the database's new features, including database management and administration enhancements, are discussed. Improvements and additions to security, architecture, Internet features, real application clusters, and performance are also detailed.

Oracle Database 10g New Features: Oracle 10g Reference for Advanced Tuning & Administration (Oracle In-Focus)

Liu, Daniel

An instructor’s guide for teaching Oracle DBA certification candidates, this book is highly technical and written for Oracle Certified Professional (OCP) DBA instructors who want to ensure that their students successfully pass their Oracle OCP certification exam. Covering those OCP topics that students find the most challenging, instructors will find targeted Oracle OCP testing content, test taking tips, and actual OCP test content. Other test topics covered include database architectures, design review meetings, software installation, database objects, backup and recovery, and tuning and performance.

Ocp Instructors Guide for Oracle Dba Certification: A Study Guide to Advanced Oracle Certified Professional Database Administration Techniques (Oracle In-Focus Series)

Foot, Christopher

See the best price to sell, buy or rent books by the Rampant TechPress publisher. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Rampant TechPress