OCP: Oracle8i^TM DBA Performance Tuning and Network Administration Study Guide: Exams 1Z0-024 & 1Z0-026

by Joseph C. Johnson; Matthew Weishan

• ISBN13: 9780782153286
• ISBN10: 0782153283
• Format: eBook
• Copyright: 2006-02-01
• Publisher: Sybex

Summary

Here's the book you need to prepare for the Oracle8i Performance Tuning and Network Administration exams (1Z0-024 and 1Z0-026). Written by Oracle8i experts, this affordable and comprehensive Study Guide provides: Full coverage of every exam objective-all the information you need to know Practical information on performance tuning and network administration in a real-world Oracle8i environment Hundreds of challenging review questions, in the book and on the CD Leading-edge exam preparation software, including testing engines and electronic flashcards A bonus chapter, exclusively on the CD, which concisely details each of the new features of Oracle8i Net8 in one convenient location Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Table of Contents

Introduction

Assessment Test

OCP: Oracle8i Performance Tuning

Introduction to Performance Tuning

Sources of Tuning Information

SQL Statement Tuning and Application Design

Tuning the Shared Pool

Tuning the Database Buffer Cache

Tuning the Redo Log Buffer

Tuning Physical I/O

Tuning Contention

Resource Management

Oracle Expert

OCP: Oracle8i Networking Administration

Introduction to Network Administration

Oracle8i Net8 Architecture

Configuring Oracle8i Net8 on the Server

Configuring Oracle8i Net8 for the Client

Centralizing Services with Oracle Names Server

Configuring the Multithreaded Server Option

Index

Table of Contents provided by Publisher. All Rights Reserved.