This book meets the objectives set forth for the Oracle9i New Features for Administrators 1Z0-030 exam, to upgrade your OCP certification from Oracle8i to Oracle9i. As such, this book is an excellent tool to prepare for the exam. Besides the technical discussions, Part 1 has many aids to help you prepare for the exam. At the end of topics you will find a For Review section and a number of questions to confirm and retain your learning. At the end of chapters, you will find a good summary that will help you review the chapter, and a number of questions. Part 2 consists of 3 practice exams with a total of 180 questions. You can purchase additional Practice tests from Oracle Corporation (see following instructions). When you take the exam, you will have to answer correctly at least 38 questions out of a total of 56 in order to successfully complete the exam. The required number of correct questions can vary based on the difficulty of the questions administered in the particular exam you take.

Daniel Benjamin has a master's degree and over fifteen years of experience Providing training and consulting solutions in Management and Information Technology for various clients including the White House, the U.S. Senate, the Department of Navy, the Department of Army, the Federal Aviation Administration (FAA), the National Air and Space Administration (NASA), the Department of Treasury Anteon Corporation, and the Washington Convention Center.
　　Dan developed the implementation strategy for President Bush's CFO Act of 1990. He also implemented a web-based learning facility in support of President Clinton's Distance Learning Initiative. He was also commended for implementing quality solutions at the White House.
　　Dan is an excellent instructor, he uses humor successfully to communicate enterprise level Internet solutions using Java, Oracle, and Microsoft technologies using UNIX and Microsoft platforms. As a senior staff member of the Rockwell University faculty he helped create a Masters Degree program in E-Commerce and Internet Security. He is a1so a featured workshop presenter at the USDA Graduate School, government agencies, and private corporations.
Dan has also authored books on Java Programming (J2SE) and Java Enterprise Connectivity (J2EE). He is a certified Workshop Facilitator for Joint Application Development and a certified Project Management Professional (PMP). Dan is also an avid guitarist and songwriter.
　　You can find additional information at www.dantastic.com. You can send feedback to dantastic@erols.com.

This book is a valuable resource for IT Management and Technical Staff; it gives them a good insight into the many enhancements in Oracle9i to address the challenges introduced by the Internet. The database has to service millions of users from around the world without compromising security even though many of the users are anonymous, without degrading performance levels, and while letting each user have a personal experience in the time and language of their locale. You have to improve availability, because downtime can have significant economic and legal impacts. Since user loads are prone to increase (a good problem for a retailer) scalability is of paramount importance. The database also needs various facilities including replicated cluster configuration to ensure that the database is available and recoverable in a contingency. Part 1 of this book discusses a vast number of Oracle9i enhancements in the areas of: security, availability, manageability,performance, scalability, language, and globalization.
　　This book also meets the objectives set forth for the Oracle9i New Features for Administrators 1Z0-030 exam, to upgrade your OCP certification from Oracle8i to Oracle9i. As such, this book is an excellent tool to prepare for the exam. Besides the technical discussions, Part 1 has many aids to help you prepare for the exam. At the end of topics you will find a For Review section and a number of questions to confirm and retain your learning. At the end of chapters, you will find a good summary that will help you review the chapter, and a number of questions. Part 2 consists of 3 practice exams with a total of 180 questions. You can purchase additional Practice tests from Oracle Corporation (see following instructions). When you take the exam, you will have to answer correctly at least 38 questions out of a total of 56 in order to successfully complete the exam. The required number of correct questions can vary based on the difficulty of the questions administered in the particular exam you take.
　　You can get the candidate guide, the test content checklist (objectives), and the exam details for the Oracle9i DBA certification paths from Oracle's OCP web site (see following instructions). The candidate guide presents the benefits of certification, describes the overall tracks and exams for each track; tells you how you can prepare, register, and take the exam; makes suggestions about steps to take after the certification, and discusses special testing opportunities where you can take the test at discounted prices.
　　Various job and salary statistics consistently show that OCP certification gives you an edge over the competition both in getting the job and jn compensation levels. Oracle9i was just released in mid-2001; the database market is just beginning to understand the power of Oracle9i and is on the lookout for Oracle9i OCPs. This certification will give both the confidence and the recognition that tilts the job interview in your favor. The certification tells the potential employer that you have attained a competency and skills level that would be needed to accomplish the day-to-day task requirements. Certification also helps companies gain a competitive edge in the marketplace when they have a team of competent, certified professionals.
　　This book is a great resource for preparing for the upgrade exam and it is an excellent reference for the new features of Oracie9i.

(美)Daniel Benjamin：暂无简介

ACKNOWLEDGMENTS
INTROOUCTION
PART 1
Oracle9i New Features Exam Guide
I Security Enhancements
Privileged Connections
Deprecation of CONN ECT INTERNAL
Deprecation of Server Manager
Stringent Default Security with the Database Creation
Assistant (DBCA)
Virtual Private Database (VPD)
Policy Management Tool
Secure Application Role
Global Application Context
Multiple Policies
Partitioned Fine-Grained Access Control
Fine-Grained Auditing (FGA)
Audit Column
Audit Event Handler
Enhancements to Encryption
Optional Security Products
Oracle Label Security
Oracle Single Sign-On (SSO)
Oracle Enterprise Login Assistant
Chapter Summary
Two-Minute Drill
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
2 Availability Enhancements
General High-Availability Technology
Minimal I/O Recovery
Fast-Start Time-Based Recovery Limit
Oracle Flashback
Resumable Space Allocation
Export/Import Features
Data Cuard
A Comprehensive Architectural Framework
Data Availability Modes
Database Role Transitions
Archive Log Gaps
Managed Recovery Process (MRP)
Delayed Redo Logs
Online Operations
Rebuilding Indexes Online
Using Index-Organized Tables (IOTs) Online
Redefining Tables Online.
Validating the Structure with the Online Analyze Command
Using the Server Parameter File (SPFILE)
Replication Enhancements
Adding New Masters Without Quiescing
Row-Level System Change Numbers
Materialized View's Fast Refresh Capability
Object Replication
Job Queue Initialization Parameters
LogMiner
OOL Statement Support
Capability to Use an Online Dictionary
DDL Tracking in the Dictionary
Dictionary Staleness Detection
Capability to Skip Log Corruptions
LogMiner Viewer
Chapter Summary
Two-Minute Drill
Fill-in-the-Blank Questions
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
3Manageability Enhancements
Database Resource Manager
Automatically Detecting and Preempting Long-Running
Operations
Automatically Limiting Resource Consumption
Segment Management
Automatic Global Index Management
External Tables
List Partitions
Metadata Application Programming Interface (API)
Automatic Segment Space Management
Bitmap join Indexes
Scalable Session Management
The Oracle Shared Server
External Procedure Agents
Multithreaded Heterogeneous Service (HS) Agents
OCI Connection Pooling
The Core Oracle Kernel Library
File Management
Creating and Managing OMFs
Automatically Deleting Non-OMF Files Using SQL
Default Temporary Tablespaces
Tablespace Management
Automatic Undo Management (AUM)
Creating and Managing UNDO Tablespaces
Multiple Block Sizes Within a Database
Database Workspace Management
The Workspace Manager Concept
Creating and Managing Workspaces
The Workspace Administrator Role
Export and Import Considerations for Workspaces
Memory Management
Automatic and Dynamic Sizing of SQL Working Areas
Views and Columns for SQL Execution Memory Management
Allocating and Tracking Memory for Dynamic SGA
Backup and Recovery
Recovery Manager (RMAN) Manageability and Reliability
Enhancements
Trial Recovery
Miscellaneous RMAN Enhancements
Oracle Enterprise Manager (OEM)
New Console Look and Feel
Standalone Mode for the Console
Integrated OEM Functionality
HTML Reports
User Defined Events
Chapter Summary
Two-Minute Drill
Fill - in-the- B1anks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
4 Performance and Scalability Enhancements
Performance Enhancements
Index Monitoring
Skip Scan Index Access
Cursor Sharing
Cached Execution Plans
First Rows Optimization
Gathering System Statistics
Real Application Clusters (RACs)
Benefits of Orac1e RACs
RAC Architecture
Resource Modes and Resource Roles
Cache Fusion
Shared Server Side Initialization Parameter File
Chapter Summary
Two-Minute Orill
Fill - in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
5 Language Enhancements
Enhancements SQL
ISO/ANSI Standardization
Constraints
FOR UPDATE WAIT
LOBs
PL/SQL
Enhancements to Globalization
New Date and Time Datatypes
Enhancements to Unicode
Enhancements to Sorting
The Character Set Scanner
Byte and Character Semantics
The Locale Builder
Chapter Summary
Two-Minute Dri1l
Fill-in-the-Blanks
Chapter Questions
Fill-in-the-Blank Answers
Answers to Chapter Questions
PART II
Oracle9i Certified Professional New Features Practice Exams
6 OCP Oracle9i Upgrade Exam: New Features for Administrators
Practice Exam 1
Practice Exam 2
Practice Exam 3
Answers to Practice Exam 1
Answers to Practice Exam 2
Answers to Practice Exam 3
Glossary
Index