OCP : Oracle8i DBA Performance Tuning and Network Administration - Study Guide

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

Authoritative coverage of all objectives for both exams, including:

• Understanding Application Tuning and Design
• Tuning the Shared Pool
• Tuning the Database Buffer Cache
• Tuning the Redo Log Buffer
• Tuning Disk I/O
• Tuning Contention
• Controlling Resource Management
• Understanding Net8 architecture
• Configuring Oracle8i Net8 on the Server
• Configuring Oracle8i Net8 on the Client
• Centralizing services with Oracle Names Server
• Configuring the Multi-threaded Server Option
• Configuring Connection Manager
• Using the Advanced Security Option
• Troubleshooting Oracle8i Net8
• Using New Features of Oracle8i Net8

Prepare for All of Oracle's DBA Track Exams with OCP Study Guides from Sybex

Featured on the CD

The enclosed CD is filled with vital preparation tools and materials, beginning with custom testing engines for the Performance Tuning and Network Administration exams. Loaded with hundreds of practice questions, these engines let you check your knowledge of the material and review areas according to chapter. You'll also find electronic flashcards for your PC and Palm devices, pre-assessment tests, and bonus practice exams. Also included is an evaluation version of Oracle8i and a fully searchable electronic copy of the book.

Contents

• Introduction
• Part 1: OCP: Oracle8i Performance Tuning
  • Chapter 1: Introduction to Performance Tuning
  • Chapter 2: Sources of Tuning Information
  • Chapter 3: SQL Statement Tuning and Application Design
  • Chapter 4: Tuning the Shared Pool
  • Chapter 5: Tuning the Database Buffer Cache
  • Chapter 6: Tuning the Redo Log Buffer
  • Chapter 7:Tuning Physical I/O
  • Chapter 8:Tuning Contention
  • Chapter 9 Resource Management
  • Chapter 10:Oracle Expert
• Part 2: OCP: Oracle8i Networking Administration
  • Chapter 11: Introduction to Network Administration
  • Chapter 12: Oracle8i Net8 Architecture
  • Chapter 13: Configuring Oracle8i Net8 on the Server
  • Chapter 14: Configuring Oracle8i Net8 for the Client
  • Chapter 15: Centralizing Services with Oracle Names Server
  • Chapter 16: Configuring the Multithreaded Server Option
• Index