OCP: Oracle 10g New Features for Administrators Study Guide: Exam 1Z0-040

by Bob Bryla; Biju Thomas

• ISBN13: 9780782143553
• ISBN10: 0782143555
• Edition: CD
• Format: Paperback
• Copyright: 2004-11-01
• Publisher: Sybex

Summary

Here's the book you need to prepare for Oracle's 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years, this book provides: Clear and concise information on the enhancements included in Oracle 10g Practical examples and insights drawn from the authors' real-world experiences Leading-edge exam preparation software, including a test engine and electronic flashcards You'll also find authoritative coverage of key exam topics, including: Installing and Configuring the Server Loading and Unloading Data Tuning Applications Supporting Analytical Applications Backing Up and Recovering Data Automating Data Storage Management Applying Security Policies Supporting Upgrade Paths to Oracle 10g Look to Sybex for the knowledge and skills needed to succeed in today's competitive IT marketplace. Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Author Biography

Bob Bryla, OCP, has worked with Oracle databases for over 10 years. He currently works as an Oracle DBA and Analyst for Lands' End in Dodgeville, Wisconsin. Biju Thomas, OCP, has over 8 years of Oracle database management and application development experience. He currently works as a Database Administrator Consultant for Burlington Resources in Fort Worth, TX.

Table of Contents

Introduction	xv
Assessment Test	xxiv
Installing and Upgrading to Oracle 10g	1	(54)
Installing Oracle 10g	2	(11)
Using the Oracle Universal Installer	3	(3)
Examining the OUI Support for New Features	6	(4)
Introducing Installation Enhancements	10	(3)
Configuring Oracle 10g	13	(13)
Examining DBCA Enhancements	14	(1)
Using the DBCA to Clone a Database	14	(3)
Simplifying Instance Configuration	17	(1)
Using the Enterprise Manager	18	(5)
Viewing Database Usage	23	(3)
Upgrading the Database	26	(20)
Introducing Upgrade-Supported Releases	27	(1)
Validating the Database Before Upgrade	28	(7)
Performing the Upgrade	35	(11)
Summary	46	(1)
Exam Essentials	47	(2)
Review Questions	49	(4)
Answers to Review Questions	53	(2)
Moving Data and Managing the Scheduler	55	(78)
Introducing Data Pump	56	(30)
Introducing the Architecture of Data Pump	57	(2)
Introducing Data Access Methods	59	(1)
Exploring the Advantages of Data Pump	60	(1)
Using Data Pump Clients	61	(22)
Using the Data Pump Wizard	83	(3)
Making Data Movement Enhancements	86	(9)
Using Cross-Platform Transportable Tablespaces	87	(3)
Writing and Projecting External Tables	90	(5)
Managing the Scheduler	95	(28)
Understanding Scheduler Concepts	96	(1)
Creating Basic Scheduler Components	97	(10)
Using the Scheduler	107	(7)
Managing Advanced Scheduler Components	114	(7)
Querying the Data Dictionary	121	(2)
Summary	123	(2)
Exam Essentials	125	(1)
Review Questions	126	(4)
Answers to Review Questions	130	(3)
Automating Management	133	(62)
Collecting Performance Statistics	134	(12)
Using the Automatic Workload Repository	135	(3)
Working with Automatic Workload Repository	138	(7)
Base Statistics and Metrics	145	(1)
Diagnosing Performance Statistics	146	(11)
Using the Automatic Database Diagnostic Monitor	147	(4)
Using Server-Generated Alerts	151	(5)
Building Your Own Alert Mechanism	156	(1)
Automating Database Management	157	(22)
Using Automatic Shared Memory Management (ASMM)	157	(3)
Tuning Automatic Undo Retention	160	(3)
Tuning the Automatic Checkpoint	163	(1)
Collecting Automatic Optimizer Statistics	164	(7)
Identifying the Advisory Framework	171	(8)
Automating Tasks	179	(1)
Resource Manager Enhancements	179	(6)
Automatic Session Switchback	180	(1)
Setting Idle Timeout	181	(1)
Creating a Mapping	181	(4)
Changes to Resource Allocation Method	185	(1)
Summary	185	(1)
Exam Essentials	186	(2)
Review Questions	188	(4)
Answers to Review Questions	192	(3)
General Storage Management	195	(48)
Managing Tablespaces	196	(23)
The SYSAUX Tablespace	197	(7)
Bigfile Tablespaces	204	(6)
Temporary Tablespace Groups	210	(3)
Other Tablespace Enhancements	213	(6)
Making Partitioning Enhancements	219	(5)
Partition Maintenance Using EM Database Control	219	(1)
Partitioned Index Organized Tables (IOTs)	220	(2)
Local-Partitioned Index Enhancements	222	(2)
Leveraging Index Enhancements	224	(6)
Skipping Unusable Indexes	224	(1)
Maintaining Index Partition Storage Characteristics	224	(6)
Bitmap Index Storage Enhancements	230	(1)
Summary	230	(2)
Exam Essentials	232	(2)
Review Questions	234	(6)
Answers to Review Questions	240	(3)
Automated Storage Management	243	(74)
Enhancing Space Management	245	(39)
Proactive Tablespace Monitoring	245	(12)
Segment Management	257	(22)
Miscellaneous Space Management Features	279	(5)
Automatic Storage Management	284	(22)
ASM Architecture	284	(2)
Creating an ASM Instance	286	(2)
ASM Instance Characteristics	288	(2)
ASM Dynamic Performance Views	290	(1)
ASM Filenames	291	(2)
ASM File Types and Templates	293	(3)
Administering ASM Disk Groups	296	(10)
Summary	306	(1)
Exam Essentials	307	(1)
Review Questions	308	(7)
Answers to Review Questions	315	(2)
Performance and Application Tuning	317	(34)
Managing Optimizer Statistics	318	(6)
Gathering Automatic Statistics	319	(1)
Leveraging Enhanced Query Optimization	320	(2)
Gathering Data Dictionary Statistics	322	(1)
Monitoring DML Tables	323	(1)
Understanding Rule-Based Optimizer Desupport	324	(1)
Understanding the SQL Tuning Advisor	324	(10)
Introducing the SQL Tuning Advisor	325	(3)
Using SQL Tuning Advisor	328	(6)
Understanding the SQL Access Advisor	334	(5)
Introducing the SQL Access Advisor	334	(1)
Using the SQL Access Advisor	335	(4)
Accessing the Database Control Performance Pages	339	(3)
Summary	342	(1)
Exam Essentials	342	(2)
Review Questions	344	(5)
Answers to Review Questions	349	(2)
Backup, Recovery, and High Availability	351	(58)
Leveraging the Flash Recovery Area	353	(8)
Flash Recovery Area Occupants	353	(1)
Flash Recovery Area and SQL Commands	354	(1)
Flash Recovery Area and the EM Database Control	355	(1)
Flash Recovery Area Management	356	(1)
Flash Recovery Directory Structure	356	(2)
Backing Up the Flash Recovery Area	358	(1)
Flash Recovery Area Data Dictionary Views	358	(3)
Flash Recovery Area Best Practices	361	(1)
Performing Incremental and Incrementally Updated Backups	361	(5)
Recovery with Incrementally Updated Backups	361	(2)
Fast Incremental Backups	363	(3)
Using Miscellaneous Backup Features	366	(9)
RMAN Command Changes	366	(2)
Online Backup Mode	368	(1)
Backing Up Different Object Types with RMAN	369	(4)
Compressed Backups	373	(2)
Introducing Miscellaneous Recovery Features	375	(1)
Fast Recovery Using Switch Database	376	(1)
Recovery Using Resetlogs	376	(1)
Flashing Back Any Logical Error	376	(22)
Flashback Database	377	(6)
Flashback Drop	383	(7)
Flashback Query	390	(5)
Flashback Table	395	(2)
Guaranteed Undo Retention	397	(1)
SCN and Time Mapping Enhancements	397	(1)
Flashback Privileges	398	(1)
Summary	398	(1)
Exam Essentials	399	(1)
Review Questions	400	(6)
Answers to Review Questions	406	(3)
Security and SQL Enhancements	409	(76)
Securing Data	411	(15)
Leveraging Virtual Private Database	411	(7)
Auditing Enhancements	418	(8)
Introducing SQL New Features	426	(32)
MERGE Improvements	426	(7)
Partitioned Outer Join	433	(5)
Spreadsheet Computations Using the MODEL Clause	438	(10)
Regular Expressions	448	(5)
Data Type Enhancements	453	(3)
Case- and Accent-Insensitive Queries	456	(1)
Quote Operator	457	(1)
Introducing Miscellaneous Database Enhancements	458	(16)
MAXTRANS Ignored	458	(1)
Flushing the Buffer Cache	459	(1)
Resumable Space Allocation	459	(1)
Materialized View Enhancements	460	(4)
Database Connectivity Improvements	464	(2)
LogMiner Enhancements	466	(1)
Transaction Rollback Monitoring	466	(1)
Tracing Enhancements	467	(7)
Summary	474	(2)
Exam Essentials	476	(1)
Review Questions	477	(5)
Answers to Review Questions	482	(3)
Appendix A SQL*Plus Enhancements	485	(6)
Enhancements to the DESCRIBE Command	486	(1)
Changes to Profile File Calls	487	(1)
Supporting Whitespace in Filenames	487	(1)
Changes to the SPOOL Command	487	(1)
Introducing New Predefined Variables	488	(1)
Changes to the SHOW Command	489	(1)
Invoking SQL*Plus	489	(2)
Appendix B New and Obsolete Initialization Parameters	491	(6)
New Parameters	492	(1)
Obsolete Parameters	493	(2)
Deprecated Parameters	495	(2)
Appendix C PL/SQL Enhancements and New Packages	497	(6)
Enhancements to the PL/SQL Compiler	498	(1)
Enhancements to PL/SQL	499	(1)
New Packages in PL/SQL	500	(3)
Glossary	503	(12)
Index	515