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