New User!
OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033
By: Joseph C. JohnsoneBook Publisher: John Wiley & Sons
Imprint: Sybex
Format: Adobe Encrypted (DRM)
Earn $0.50 - Write a Review »
"Here's the book you need to prepare for Exam 1Z0-033: Oracle9i Database: Performance Tuning.
This Study Guide provides: In-depth coverage of official exam objectives Practical information on optimizing Oracle9i databases Hundreds of challenging review questions, in the book and on the CD
Authoritative coverage of all exam objectives, including: Using Diagnostic and Tuning Tools Monitoring and Managing the Buffer Cache Optimizing Sort Operations Detecting and Resolving Lock Contention Diagnosing Shared Server Performance Issues Using Oracle Blocks Efficiently Tuning SQL Statements Configuring Resource Manager
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file. "
See more like this in our Computers eBooks section
Share your thoughts on the OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033 Computers eBook with others!
| Title of Computers eBook: OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033 | |
| Release Date: 02-20-2006 | |
| Publisher: Sybex |
This eBook download is available in the following formats:
| Parent title | OCP: Oracle9i Performance Tuning... |
|---|---|
| Encrypted (DRM) | Yes |
| SKU | 9780782152746 |
| File size | 3456 |
| Security | n/a |
| Printing | Not allowed |
| Copying | Not allowed |
| Read aloud | No Sys requirements Download reader |
| Devices | Samsung Tablet, Apple Ipad & Iphone, Barnes & Noble Nook, Kobo eReader, Aluratek Libre, Iliad, Nokia, Blackberry, Hanlin |
| Note | Excellent navigation features are available via Adobe such as bookmarks and a quick access table of contents. Text search is easily accessible. An Adobe DRM-protected file is different than a pdf file in that it uses Adobe DRM (Digital Rights Management) technology, which authors and publishers use to protect their content from illegal online distribution and to set certain privileges such as restrictions on copying and printing. |
OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033
Chapter One
Introduction to Performance TuningORACLE9i PERFORMANCE TUNING EXAM OBJECTIVES COVERED IN THIS CHAPTER:
Describe the roles associated with the database tuning process
Describe the dependency between tuning in different development phases
Describe Service Level Agreements
Describe appropriate tuning goals
Describe the most common tuning problems
Describe the tuning considerations during development and production
Describe performance and safety tradeoffs
NOTE
Exam objectives are subject to change at any time without prior notice and at Oracle's sole discretion. Please visit Oracle's Certification website (http://www.oracle.com/education/ certification/) for the current exam objectives listing.
"Why is the system so slow?" The ability to answer this question definitively and authoritatively is one of the most important skills for an Oracle DBA to possess. Acquiring this skill requires a thorough understanding of the Oracle Server architecture, as well as knowledge of how Oracle processes SQL statements and how Oracle interacts with host operating systems and server hardware. Consequently, tuning an Oracle database can be a daunting task. Indeed, Oracle9i is so tunable and so feature-rich that it's often difficult to know where to begin your tuning effort. Because of this, the application of proven tuning methodologies is the key to a successful tuning exercise.
This chapter will introduce the concepts related to selecting an appropriate performance tuning methodology and then
...Read full excerpt from OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033 ebook








