Skip to main content

OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033

OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033

Joseph C. Johnson

ISBN: 978-0-782-14065-1

Jul 2002

602 pages

Select type: Hardcover

Product not available for purchase


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.

IntroductionxviiAssessment Test.

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.
ChapterPageDetailsDatePrint Run
Combined Errata

Page 19

The last sentence on page should read .. temporary connections to the database as a user navigates through the application can contribute...

Page 39

Note should read You may occasionally be asked to activate tracing for database events..

Page 88

Table 3.1, EXPLAIN Option ..using the PLAN_TABLE in the schema specified by this option.

Page 133

18th line should read USE_STORED_OUTLINES

Page 155

5th line, Three should be changed to two in this sentence.

Page 173

The code snippet at the bottom of page 173 is incorrect. It should be,
SQL> CREATE TABLE student_history
2 (student_id NUMBER(10),
3 degree VARCHAR2(3),
4 graduation_date DATE,
5 final_gpa NUMBER)
6 PARTITION BY RANGE (graduation_date)
8 STORE IN (hist_tab01,hist_tab02,hist_tab03,
9 hist_tab04,hist_tab05,hist_tab06)
11 (TO_DATE('01-JUN-1997','DD-MON-YYYY')),
13 (TO_DATE('01-JUN-1998','DD-MON-YYYY')),
15 (TO_DATE('01-JUN-1999','DD-MON-YYYY')),
17 (TO_DATE('01-JUN-2000','DD-MON-YYYY')),
19 (TO_DATE('01-JUN-2001','DD-MON-YYYY')),

Page 231

First sentence of Tune Library Cache-specific init.ora Parameters Should read In addition to SHARED_POOL_SIZE, there are four init.ora parameters...

Page 232

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.

Page 247

Last sentence before heading User Server Process Should read ...use of the Dirty List while carrying out..

Page 294

First sentence after code snippet at top of page should read The above output from the ps command shows that six Shared Server processes...

Page 296

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.

Page 309

Second bullet (replace entire sentence)Should read Recovery Manager backup and restore operations utilizing I/O slaves

Page 310

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?

Page 319

Question 16 Should read What is the default size of the Large Pool? not What is the minimum size of the Large Pool?

Page 381

First Run-In, Control Files Should read The Log Writer and Checkpoint background.... not The Database Writer and Checkpoint background...

Page 385

Note at top of page should read .. in Oracle9i Concepts, Release 1 (9.0.1) (Part Number...)

Page 397

Understanding Oracle Blocks and Extents section, 6th sentence Should read ? most systems can use 2K, 4K, 8K, 16K, and 32K block sizes.

Page 441

Improving Rollback Segment I/O section, last sentence before bullets Should read ....consider these five tuning categories: not ....consider these four tuning categories:

Page 443

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....

Page 509

Third sentence from end of page - Should read The techniques used to monitor paging and swapping vary by operating system.

Page 511

The last sentence should read Table 10.4 describes four common server architectures .

Page 515

First sentence under Figure 10.3 Should read .....server contains one CPU - as evidenced by the single CPU Usage History graph.

Page l

Explanation 58 should read The LAST_ANALYZED column in the DBA_TABLES view will....

Page xlvii

Explanation 30, 4th sentence .... V$SQLTEXT may be contains in several rows... should read ... V$SQLTEXT may be in several rows..

Page xxvii

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??

Page xxxix

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.

Page xxxv

Question 32, 2nd sentence should read .... of the following items? (choose four)