Sybex

Home Certification IT Administration Architecture & Design
3D Animation & CGI Internet Marketing
Print this page Share

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

ISBN: 978-0-7821-4065-1
602 pages
July 2002
OCP: Oracle9i Performance Tuning Study Guide: Exam 1Z0-033 (0782140653) cover image
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

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.

Glossary.

Index.

See More
Joseph Johnson is an OCP in database administration with more than 7 years' experience with Oracle databases. He is currently a senior DBA for Greenbriar & Russel in Milwaukee. Johnson was the coauthor of Sybex's Oracle8i DBA Performance Tuning and Network Administration Study Guide.
See More
Download TitleSizeDownload
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
See More

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.

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)
7 SUBPARTITION BY HASH(student_id)SUBPARTITIONS 6
8 STORE IN (hist_tab01,hist_tab02,hist_tab03,
9 hist_tab04,hist_tab05,hist_tab06)
10 (PARTITION p_1997 VALUES LESS THAN
11 (TO_DATE('01-JUN-1997','DD-MON-YYYY')),
12 PARTITION p_1998 VALUES LESS THAN
13 (TO_DATE('01-JUN-1998','DD-MON-YYYY')),
14 PARTITION p_1999 VALUES LESS THAN
15 (TO_DATE('01-JUN-1999','DD-MON-YYYY')),
16 PARTITION p_2000 VALUES LESS THAN
17 (TO_DATE('01-JUN-2000','DD-MON-YYYY')),
18 PARTITION p_2001 VALUES LESS THAN
19 (TO_DATE('01-JUN-2001','DD-MON-YYYY')),
20 PARTITION p_ERROR VALUES LESS THAN (MAXVALUE));

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)"


See More