Oracle9i RAC Oracle Real Application Clusters Configuration and Internals 1st Edition by Mike Ault, Madhu Tumma, Don Burleson ISBN 978-0972751308 0972751300

Oracle9i RAC Oracle Real Application Clusters Configuration and Internals 1st Edition by Mike Ault, Madhu Tumma, Don Burleson – Ebook PDF Instant Download/Delivery: 978-0972751308, 0972751300
Full download Oracle9i RAC Oracle Real Application Clusters Configuration and Internals 1st Edition  after payment

Product details: 

ISBN 10:  0972751300

ISBN 13: 978-0972751308 

Author: Mike Ault, Madhu Tumma, Don Burleson

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.

Table of contents: 

Chapter 1 – Getting Started

Why Become an Oracle Database Administrator?.

Oracle Database Administration Responsibilities

Oracle Classroom Education…

Oracle9i Curriculum Changes..

Oracle9i Oracle Certifications

Oracle Certified Database Associate (OCA).

Oracle Certified Database Professional (OCP)..

Oracle Certified Master Database Administrator (OCM).

Oracle9i DBA OCP Upgrade Path..

Other Recommend Classes.

Preparing for the Oracle Certified Professional Exams.

Taking the Certification Exams.

Finding Information Quickly – The Key to Success.

Reference Manuals..

Oracle Internal Resources…

External Resources…

Book Recommendations

Conclusion

Chapter 2 – Oracle Database Architectures

Oracle Database Architectures.

Oracle on Microsoft Windows Platforms.

Oracle on LINUX Platforms…..

Oracle on Unix Platforms

Database Architecture Comparison Worksheet.

Venturing into the Great Unknown – New Database

Architectures.

Table of Contents

Conclusion

Chapter 3 – Review Meetings.

Oracle Database Design Review Meetings..

Initial Overview of Proposed System…..

Logical Data Model Review.

Designing for Performance..

Setting up a Successful Test System in Oracle..

Monitoring Performance During Testing..

Performance Design Reviews……

Preparation for Production Turnover.

Post Production Turnover

Oracle Database Design Review Meetings – Conclusion.

Conclusion

Chapter 4 – Oracle Database Administration.

Oracle Software Installation.

Migrating to Newer Oracle Releases

UNIX and LINUX Semaphores and Shared Memory.

Semaphores……..

Shared Memory

Relinking Oracle8i and Oracle9i Products…

Windows Services

Oracle Instance Administration

Oracle9i Persistent Initialization Parameter Files.

Remote Startup/Shutdown..

Multiple Buffer Pools..

Specifying Default, Keep and Recycle Bufferpools in Oracle8 and Oracle8i.

Specifying Default, Keep and Recycle Bufferpools in Oracle9i

Large Pool…….

Java Pool

Redo log Buffer Performance..

Buffer Performance is critical to Good Oracle Performance…

DBWR_IO_SLAVES vs DB_WRITER_PROCESSES

Conclusion

Chapter 5 – Oracle Database Objects

What Database Are You Working In?

Choosing a Database Block Size.

Copying Databases Between Servers..

Oracle Tablespaces..

Temporary Tablespaces.

Create Tablespace Temporary vs. Create Temporary Tablespace.

Partitioning

Oracle 8 – Range Partitioning.

Index Partitioning..

Equi-Partitioned Objects..

Local Indexes.

Global Indexes

Oracle8i – Hash and Range/Hash Composite Partitioning…..

Hash Partitioning..

Combining Range and Hash Partitioning-Range/Hash Composite

Partitioning.

Oracle9i – List and Range/List Composite Partitioning..

List Partitioning..

Range/List Composite Partitioning.

Which Partitioning Technique Do I Choose?.

Oracle9i Tablespace Changes.

Locally Managed System Tablespaces.

Rollback Segments..

When is the System Rollback. Segment Used?..

Rollback Segments and Transaction Processing Workloads.

Batch and On-line Processing.

Rollback Segments and Users – Who’s Using What?.

Oracle9i – Database Managed Undo Segments..

Redo Logs.

Checkpoint Not Complete..

Resizing Redo Logs.

Oracle Tables and Indexes.

Space Utilization for Parallel Table Creates..

Index-only Tables.

Single Table Hash Clusters.

Oracle9i External Tables

ALTER TABLE MOVE Statement.

ALTER COLUMN RENAME.

On-Line Table Reorganizations

PCTFREE and PCTUSED.

Clustering Data in Tables

Merging Tables to Increase Query Performance.

How Many Indexes Can I Build?

Parameters that Impact Index Usage.

Index-Only Access

Index Rebuilds

Index Coalesce vs Index Rebuild

Function-Based Indexes

Bitmap Indexes

Optimizer and Bitmap Indexes

Concurrency and Bitmap Indexes.

When to Use Bitmap Indexes..

Bitmap vs B-Tree..

Indexing Hints Tips and Tricks.

Index Monitoring..

Conclusion

Chapter 6 – Oracle Backup and Recovery.

It’s the Little Things That Bite You……

Keep Your Skills Sharp.

RELAX and Plan Your Attack.

Don’t Be Afraid to Ask Others

Instance Recovery and the Oracle Synchronization Process..1

Uncommitted Data on the Data Files….

Committed Data Not On the Data Files..

The Synchronization Process…

Roll Forward Phase..

Roll Backward Phase.

Exports and Recovery.

VSRECOVERFILE

Watch the NOLOGGING Option.

Striped File Systems..

Data Files and Redo Logs

Redo Log and Control File Multiplexing..

OCOPY for Windows

Hot Backup Scripts for Windows

Hot Backup Scripts for UNIX

Oracle9i – Lazy Checkpointer.

Recovery Manager.

Recovery Catalog..

Recovery Manager Backup Types.

Backup Sets

Image Copies.

Parallel Backup and Recovery..

Multiplexed Backup Sets…….

Backup/Recovery Reports..

Database Recovery..

RMAN Examples.

db_verify

Conclusion

Chapter 7 – Tuning and Performance

Be careful with the ANALYZE command

Finding Problem Queries

Optimizer Plan Stability.

Pinning Objects in the Shared Pool.

PCTFREE and PCTUSED.

Caching Tables..

Clustering Data in Tables

Merging Tables to Increase Query Performance.

Hints

Parallel Hints

Performance Testing.

Parallel Query.

Tuning Oracle on Windows.

Tuning Pack.

Direct Load Inserts.

Parallel DML Processing.

Materialized Views…

Database Resource Management.

STATSPACK

V$ TABLES vs. Oracle BSTAT/ESTAT and STATSPACK

Segment-Level Performance Statistics Collection.

Performance Tuning Intelligent Advisories

Optimizer Dynamic Sampling.

Data Segment Compression……….

Using Explain Pan to Determine Access Paths.

Explain Plan Output.

SQL*PLUS AUTOTRACE.

High Water Mark and Table Scans

Allocating too Much Memory to the Shared Pool and Data

Buffers

Conclusion

Chapter 8 – Miscellaneous Oracle Information

The Foot Rule of Thumb..

Monitor By Day So You Don’t Get Called at Night.

Monitoring Space Utilization and Performance Statistics

Historically.

Latches and Enqueues

Deadlock Detection

Unindexed Foreign Keys and Locking Problems…

Using PUPBLD

Copying databases between servers…

Oracle9i – Resumable Space Allocation

Oracle9i – Flashback Query.

Full Database Exports

Large Table Imports.

Compressing Export Output Files in UNIX

Terminating Oracle Processes (Threads) in Windows

Systems.

Truncating vs Deleting..

Copy Command in SQL*PLUS

Displaying Time in Milliseconds.

!, $ and Host Command Differences.

Learn Command Line BEFORE Using “Sissy GUI Tools”

Oracle Enterprise Manager.

Don’t Write Scripts…

Don’t’ Write Iterative SQL Statements – Generate SQL wit

SQL…..

Input Truncated to 9 Characters.

Conclusion

Chapter 9 – Evaluating Third-Party Products.

Initial Analysis

Determine Impact to the Information Technology Support

Infrastructure….

Analysis Evaluation

Obtain Business Unit and IT Management Commitment……

Create Evaluation Team

Locate Potential Vendors

Initial Elimination…

Vendor Evaluation

Communicate Results

Conclusion

Chapter 10 – Ease of Administration..

Good Documentation is Essential..

Follow OFA Naming Conventions

Proceduralize Administrative Support for the Application

Development Process.

Proceduralize the Change Request Process.

Create and Standardize Monitoring and Administration

Scripts.

Repeatable Processes.

Create Service Level Agreements.

DBA Report Cards and the 360-Degree Review Process..

Corrective Action Reports

Conclusion

Chapter 11 – Oracle Database Security.

Protecting Data Requires More than just Protecting the

Production Database…..

Identifying Granted Privileges..

Accounts Created During Database Creation..

Wrapping PL/SQL Programs..

Using OPS$ Accounts

Using Security Profiles…

SYS and SYSTEM Passwords

GRANT ANY OBJECT Privilege.

Administrative User Auditing.

Moving the AUD$ Table..

Conclusion

Chapter 12 – Certification Test Preparation.

Introduction.

Oracle Certified Associate Tests

Exam 1Z0-007- Introduction to Oracle9i SQL..

Exam 1Z0-031 – Oracle Database Fundamentals I..

Oracle Certified Professional Tests

Exam 1Z0-032 – Oracle Database Fundamentals II

Exam 1Z0-033- Oracle Database Performance Tuning..

Conclusion

People also search for:

    
oracle 8i documentation
    
oracle 4
    
a oracle
    
is oracle rac supported in aws
    
oracle rac vmotion

Tags: Mike Ault, Madhu Tumma, Don Burleson, Oracle9i RAC, Real Application, Clusters Configuration