OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033
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.
Chapter1 Introduction to Performance Tuning.
Chapter2 Sources of Tuning Information.
Chapter3 SQL Application Tuning and Design.
Chapter4 Tuning the Shared Pool.
Chapter5 Tuning the Database Buffer Cache.
Chapter6 Tuning Other SGA Areas.
Chapter7 Tuning Redo Mechanisms.
Chapter8 Tuning Disk I/O.
Chapter9 Tuning Contention.
Chapter10 Operating System Tuning.
|Download Images Used in the Book
Download a .zip file with the images from the book.
To uncompress the file, Windows users can use Windows built-in ZIP utilities or a 3rd party utility like WinZip or WinRAR. Macintosh users can simply double-click the downloaded file to extract using the built-in archive utility.
|2.76 MB||Click to Download|
Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.
The last sentence on page should read ".. temporary connections to the database as a user navigates through the application can contribute..."
Note should read "You may occasionally be asked to activate tracing for database events.."
Table 3.1, EXPLAIN Option "..using the PLAN_TABLE in the schema specified by this option."
18th line should read "USE_STORED_OUTLINES"
5th line, "Three" should be changed to "two" in this sentence.
The code snippet at the bottom of page 173 is incorrect. It should be,
First sentence of "Tune Library Cache-specific init.ora Parameters" Should read "In addition to SHARED_POOL_SIZE, there are four init.ora parameters..."
The third sentence in the SESSION_CACHED_CURSORS section should read: "If your application is form-based, setting this parameter to a non-zero value may improve the Library Cache hit ratio."
Last sentence before heading "User Server Process" Should read "...use of the Dirty List while carrying out.."
First sentence after code snippet at top of page should read "The above output from the ps command shows that six Shared Server processes..."
The description for Dispatchers in Table 6.1 should read "Used to specify the number of Dispatchers to spawn at instance startup and the Oracle Net protocol assigned to each Dispatcher. The default value is 1.
Second bullet (replace entire sentence)Should read "Recovery Manager backup and restore operations utilizing I/O slaves"
Real World Scenario, last paragraph change to read "When the Large Pool is present, and RMAN has been configured to use I/O slaves through the use of the DISK_IO_SLAVES or BACKUP_TAPE_IO_SLAVES init.ora parameters, RMAN will use the Large Pool to buffer?"
Question 16 Should read "What is the default size of the Large Pool?" not "What is the minimum size of the Large Pool?"
First Run-In, Control Files Should read "The Log Writer and Checkpoint background...." not "The Database Writer and Checkpoint background..."
Note at top of page should read ".. in Oracle9i Concepts, Release 1 (9.0.1) (Part Number...)"
Understanding Oracle Blocks and Extents section, 6th sentence Should read "? most systems can use 2K, 4K, 8K, 16K, and 32K block sizes."
Improving Rollback Segment I/O section, last sentence before bullets Should read "....consider these five tuning categories:" not "....consider these four tuning categories:"
Last sentence at bottom of page, onto top of next page Should read "For example, one of user rbron's transactions is generating 280 blocks worth...."
Third sentence from end of page - Should read "The techniques used to monitor paging and swapping vary by operating system."
The last sentence should read "Table 10.4 describes four common server architectures".
First sentence under Figure 10.3 Should read ".....server contains one CPU - as evidenced by the single CPU Usage History graph."
Explanation 58 should read "The LAST_ANALYZED column in the DBA_TABLES view will...."
Explanation 30, 4th sentence ".... V$SQLTEXT may be contains in several rows..." should read "... V$SQLTEXT may be in several rows.."
Assessment test Question 4 "Which default resource group should the BDA put these users in?? should be "Which default resource group should the DBA put these users in??
Assessment test Question 46 "The DBA has determined that Free List contention in occurring on several busy application tables." Should be "The DBA has determined that Free List contention is occurring on several busy application tables."
Question 32, 2nd sentence should read ".... of the following items? (choose four)"