OCP Oracle9i Database: New Features for Administrators Exam Guide


Prepare to pass the Oracle9i Certified Professional DBA New Features for Administrators exam using this Oracle Press study guide. You'll get complete coverage of all exam topics followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice ...
See more details below
Available through our Marketplace sellers.
Other sellers (Multimedia Set)
  • All (12) from $1.99   
  • New (4) from $45.23   
  • Used (8) from $1.99   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
Seller since 2014

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

0072195304 New Book. Please allow 4-14 business days to arrive. We will ship Internationally as well. Very Good Customer Service is Guaranteed!! Millions sold offline.

Ships from: Newport, United Kingdom

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2008

Feedback rating:


Condition: New
0072195304 New. Looks like an interesting title!

Ships from: Naperville, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2014

Feedback rating:


Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2014

Feedback rating:


Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by
Sending request ...


Prepare to pass the Oracle9i Certified Professional DBA New Features for Administrators exam using this Oracle Press study guide. You'll get complete coverage of all exam topics followed by practice questions and chapter summaries. The CD-ROM contains hundreds of practice exam questions in an adaptive format.

Get Certified with Official Exam Prep Material from Oracle Press

Prepare for the Oracle Certified Professional Oracle9i Database: New Features for Administrators exam—a required exam for upgrading your Oracle8i or earlier DBA certification—using this Oracle Press study guide. Throughout each chapter,you'll find in-depth details on all the material covered on this challenging exam,followed by practice questions and chapter summaries to highlight what you've learned. Authorized by Oracle Corporation,this book and CD-ROM package is the most comprehensive preparation tool available for the Oracle9i Database: New Features for Administrators exam.

  • 100% complete coverage of all official exam objectives
  • Exercises at the end of all discussions that reinforce your Oracle knowledge right away
  • Tips,examples,and reviews in every chapter to help you remember key concepts
  • Two-minute drills—quick and concise checklists that summarize each chapter's main points
  • Chapter self-tests—exam-based questions complete with in-depth explanations
  • More than 300 practice questions—including scenario-based questions

Book and CD-ROM include more than 300 interactive exam-based questions. CD-ROM contains interactive exams that simulate the actual OCPexams and include hotlinked questions,answers,and explanations.

Read More Show Less

Product Details

  • ISBN-13: 9780072195309
  • Publisher: McGraw-Hill Companies, The
  • Publication date: 3/1/2002
  • Series: Osborne Oracle Press Series
  • Pages: 396
  • Product dimensions: 7.40 (w) x 9.16 (h) x 1.08 (d)

Meet the Author

Daniel K. Benjamin has a masters degree and over fifteen years of experience providing training and consulting solutions in Information Technology and Management to various clients including the White House, the U.S. Senate, the Department of Navy, the Department of Army, the Federal Aviation Administration (FAA), the Department of Treasury, Anteon Corporation, and the Washington Convention Center.
Read More Show Less

Read an Excerpt

Chapter 2: Availability Enhancements

The downtime of production databases can have a significant impact on the organization: You can lose revenue, you can lose credibility, you can lose customers, you can lose orders, you may not deliver on obligations, you may violate contract requirements for uptime, and you may encounter legal proceedings. This chapter discusses the following:
  • General high-availability technology
  • Data guard
  • Online operations
  • Replication enhancements
  • LogMiner

General High-Availability Technology

Oracle 9i introduced a number of enhancements to its comprehensive data availability solution. For example, Oracle9i realizes that downtime is an eventuality, and that one aspect of database availability is to minimize the amount of downtime by focusing on recovering from an outage very quickly.

Some of the high-availability enhancements are

  • Minimal input/output (I/O) recovery
  • Fast-start time-based recovery limit
  • Oracle Flashback
  • Resumable space allocation
  • Export/import features

Minimal I/O Recovery

Oracle9i recognized that failure is a reality and focused specifically on recovering rapidly from the outage by optimizing the speed with which it can apply redo logs. One obvious solution is to use disks and drivers that can quickly access the logs and can transfer the data into memory rapidly. A second solution is to ensure that the redo logs reside in a contiguous area on disk. A third solution is to minimize the number of redo entries that must be read and applied; this concept is called minimal I/O recovery.

Oracle documents every change that is made to the database in the redo log. Changes are recorded in the redo log as redo entries, which are comprised of a set of change vectors. A change vector tracks a specific change that is made to a single data block. The redo logs also track the rollback segments in the database. Oracle uses the redo log to recover from a database crash. Oracle scans the redo logs, reads the change vectors, and applies them to the corresponding data block in the database.

To recover from a crash, you must recover the data blocks in the cache that were dirty at the time of the failure. The entries that pertain to the dirty blocks in the data cache are documented in the redo log. However, the redo log is very likely to contain entries for dirty data blocks that were written back to disk before the crash, and therefore were not dirty at the time of the failure. Oracle9i optimized the recovery process to exclude the redo log entries that do not apply to blocks that were dirty at the time of the failure (see Figure 2-1).

Oracle first does a quick pass through the redo logs to identify the change vectors that pertain to the dirty blocks and then stores this information in the PGA. In a second pass, Oracle uses the information in the PGA to apply just the identified changes. Since Oracle only sequentially reads the online log and does not actually access the data blocks themselves, the overall time to recover is minimized by the two-pass approach.

Fast-Start Time-Based Recovery Limit

Oracle9i periodically stores the checkpoint redo byte address (RBA) in the redo log. A checkpoint is designated by a system change number (SCN) in the control file. The checkpoint assures you that all data blocks with an SCN that is less than or equal to the checkpoint SCN have been written to disk. In the event of a failure, only redo entries with an SCN higher than the checkpoint SCN need to be read and applied. More specifically, the checkpoint RBA identifies the starting point in the redo log from which redo entries must be applied.

The time to recover is dependent on how recently the last checkpoint was done, since it determines the number of data blocks with a higher SCN than the checkpoint SCN. The time to recover is also dependent upon the number of redo log blocks that must be read to identify changes. Therefore, frequent checkpointing actions result in a lower time for instance recovery; the price for this benefit is the adverse impact on performance. This performance degradation occurs because checkpointing uses the database writer (DBWn) processes. You must make a trade-off between instance recovery time and operational database performance.

Oracle9i introduces the fast-start checkpointing architecture to implement fast-start instance recovery functionality. The fast-start checkpointing architecture performs incremental checkpointing, and it writes the oldest dirty blocks first to ensure that the most recent dirty blocks are associated with a higher SCN. You can now specify the target mean time to recover (MTTR) for the instance recovery by assigning the initialization parameter FAST_START_MTTR_TARGET a value between 0 and 3,600 seconds. When you set this parameter to 0, Oracle9i will not use this parameter to manage instance recovery time. The optimal value for FAST_START_MTTR_TARGET depends upon the database utilization, the system global area (SGA) size, and the Service Level Agreement (SLA) for that site. Your challenge is to optimize the FAST_START_MTTR_TARGET parameter such that it is in accordance with the SLA without an undue degradation in operational performance. You can verify checkpoint statistics with the Statspack and by querying the V$INSTANCE_RECOVERY view.

Oracle9i added the following three columns to V$INSTANCE_RECOVERY:

  • TARGET_MTTR The user's setting for the FAST_START_MTTR_TARGET parameter
  • ESTIMATED_MTTR The MTTR that is estimated based on the number of dirty blocks and the number of redo log blocks
  • CKPT_BLOCK_WRITES The number of data blocks that were written by the checkpoint write operation
You can set the FAST_START_MTTR_TARGET parameter dynamically with the following statement:

Oracle internally uses the FAST_START_MTTR_TARGET parameter value to calculate and set the FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL parameters. If you specify the FAST_START_IO_TARGET and LOG_CHECKPOINT_INTERVAL parameter values, they will override the values Oracle calculates from the FAST_START_MTTR_TARGET parameter.

Some parameters that you use to manage instance recovery are as follows:

  • The LOG_CHECKPOINT_INTERVAL parameter value specifies the maximum number of redo blocks that you can have after the checkpoint. You can eliminate checkpoint intervals by setting LOG_CHECKPOINT_INTERVAL to 0 (zero).
  • The LOG_CHECKPOINT_TIMEOUT parameter specifies the maximum number of seconds of redo logging action after the checkpoint.
  • The FAST_START_IO_TARGET parameter specifies the number of data blocks that must be recovered with the two-pass minimal I/O recovery.
  • The DB_BLOCK_MAX_DIRTY_TARGET parameter specifies the maximum number of dirty data blocks that you can have in the buffer cache. This parameter has been retired in Oracle9i.

Oracle Flashback

Oracle Flashback enables you to query the database as of a certain time or a specific SCN in the past. All DML operations that were committed prior to that specific time or SCN are included, while data that was committed after the specific time or SCN is not.

Some applications where Oracle Flashback is useful are

  • Decision support systems (OLAP)
  • Document management systems and e-mail systems
  • Database repair
When working with decision support systems, Flashback enables you to analyze data as of a past time period. When using databases, document management systems, and email systems, Flashback enables you to recover database rows, documents, or emails that were accidentally deleted by stepping back to a time or SCN before the deletion and save the document or email in the current period (see Figure 2-2).

Here is an example:

1. All the rows of the database are intact at 10:25; the database is at SCN#1.

2. The user accidentally deletes critical rows of information at 10:28; the database is at SCN#2.

3. The user recognizes this loss of information at 10:29.

4. At 10:30, the user flashes back to the database at SCN#1 before the information was deleted and retrieves the "missing" rows into a PL/SQL cursor.

5. At 10:32, the user returns to the current database by disabling the flashback and inserts the missing data from the PL/SQL cursor.

Requirements for Flashback
Here are some requirements in order to use Flashback:
1. You must use automatic undo management as opposed to the older technique of rollback segments:

2. You must set the initialization parameter UNDO_RETENTION to specify how far back in seconds Oracle should retain undo information and therefore how far back you can perform a Flashback query. You can also update this parameter dynamically with the following statement:


3. You must have EXECUTE privilege on the DBMS_FLASHBACK package....

Read More Show Less

Table of Contents

Pt. I Oracle9i New Features Exam Guide
1 Security Enhancements 3
2 Availability Enhancements 41
3 Manageability Enhancements 121
4 Performance and Scalability Enhancements 211
5 Language Enhancements 241
Pt. II Oracle9i Certified Professional New Features Practice Exams
6 OCP Oracle9i Upgrade Exam: New Features for Administrators 289
Glossary 365
Index 383
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted June 20, 2003

    Useless for certification

    This book has too many mistakes, even after checking the errata. Section on Advanced Replication is very poor. Many facts that are presented are incorrect. Do not expect much similarity with the Oracle 9i Upgrade Exam 1Z0-030.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)