OCP: Oracle8i TM DBA Performance Tuning and Network Administration Study Guide / Johnson Joseph C. and Weishan Matthew
Publication details: San Francisco: SYBEX, c2000.Description: xxiii, 771 p. : ill. ; 24 cm. + CD-ROMISBN:- 0782126847
- 22 005.447 JOH
Item type | Current library | Call number | Copy number | Status | Date due | Barcode |
---|---|---|---|---|---|---|
Book Open Access | Engineering Library | 005.447 JOH 1 (Browse shelf(Opens below)) | 1 | Available | BUML23111388 |
CONTENTS
Part 1: OCP: Oracle8i Performance Tuning
Chapter 1: Introduction to perform Tuning
The Oracle Tuning Methodology
Goal-oriented tuning
General tuning concepts
Review of the oracle architecture
Chapter 2: Sources of tuning information
The Alert Log
Background, event, and user trace files
Performance tuning views
Oracle-supplied tuning scripts
Graphical Performance tuning tools
Chapter 3: SQL Statement tuning and Application Design
Measuring SQL Performance
Understanding the oracle optimizer
Setting the optimizer mode
Improving APPLICATION PERFORMANCE
OLTP vs DSS tuning requirements
Chapter: 4 Tuning the shared pool
Understanding the shared pool
Measuring the performance of the shared pool
Improving shared pool performance
Chapter 5: Tuning the database buffer cache
Understanding the database buffer cache
Measuring the performance of the database buffer cache
Improving buffer cache performance
Chapter 6: Tuning the redo log buffer
Understanding the redo log buffer
Measuring the performance of the redo log buffer
Improving redo log buffer performance
Chapter 7: Tuning Physical I/O
Tuning Data-file Performance
Tuning DBW0 Performance
Tuning Segment block I/O
Tuning redo log and LGWR I/O
Tuning checkpoints and CKPT I/O
Etc.
Chapter 8: Tuning Contention
Latch Contention
Free list Contention
Lock Contention
Chapter 9: Resource Management
Resource Manager Overview
Configuring resource management
Monitoring resource manager
Chapter 10: Oracle Expert
Starting oracle expert
Oracle expert scope
Collecting tuning statistics
Viewing statistics and editing rules
Reviewing recommendations and generating scripts
Etc.
Part 2: OCP: Oracle8i Network Administration
Chapter 11: Introduction to Network administration
Network design considerations
Network responsibilities for the DBA
Network configurations
Overview of Net8 features
Advanced security options
Etc.
Chapter 12: Oracle8i Net8 Architecture
Establishing connections to oracle servers
The Net8 stack Architecture
Chapter 13: Configuring Oracle8i Net8 on the server
The Oracle listener
Starting and using the Net8 Assistant
Managing the listener using Isnrctl
New feature: automatic registration of services
Chapter 14: Configuring Oracle8i Net8 for the client
Client-side names resolution options
Configuring load balancing and failover
Chapter 15: Centralizing services with oracle names server
The Oracle name server
Configuring a names server with Net8 assistant
The Namesctl Utility
Configer clients to use names server
Auto-registration of services with a names server
Etc.
Chapter 16: Configuring the multithreaded server option
Multithreaded server configuration
Configuring the multithreaded server option
Starting the instance and managing multithreaded server
Requesting a dedicated connection in a multithreaded environment
Connection pooling
Etc.
Chapter 17: Connection Manager Configuration
Connection manager features
Connection manager process
The cman.ora file
Managing Connection manager
Configuring connection Concentration
Etc.
Chapter 18: Advanced Security Option
Security Concerns in the Enterprise
Data Security Features
Authentication methods
Authentication configuration parameters
Chapter 19: Troubleshooting Oracle8i Net8
Diagnosing and correcting connection problems
Net8 Logging and testing
Includes: Glossary: p. 741-749 . _ . Index: p. 751-771
There are no comments on this title.