Sumário Itens Encontrados: 378CHAPTER 1 Installing, Upgrading, and Managing Change 1New Features in Server Installation 2Changes in the Optimal Flexible Architecture 2Changes in the Install Options 3New Oracle Database 11g Components 4Role and Privilege Changes 5Installing Oracle Database 11g 6New Features in Database Creation 8New Initialization Parameters 8DBCA Enhancements 13New Oracle Background Processes 16New Oracle-Supplied PL/SQL Packages 17Upgrading to Oracle Database 11g 17Upgrading and the Compatibility Factor 18Upgrade Path to Oracle 11g 18Upgrading with the DBUA 24Performance Testing the Upgrade 25Downgrading After an Upgrade to 11g 25Rolling Upgrade Enhancements 26Oracle Clusterware Upgrade 26Real Application Testing 35Database Replay 35The SQL Performance Analyzer 47Database Software Patching 53New Features in Database Control for Patching 53Emergency Hot Patching (Online Database Patching) 55Database Change Management Pack 56Software and Database Cloning 56CHAPTER 2 Database Diagnosability and Failure Repair 57The Fault Diagnosability Infrastructure 58Problems and Incidents 60Incident Packaging Service 61Structure and Location of the ADR 61Investigating and Resolving Problems 63Using the Command-Line Tool adrci 63The Support Workbench 73Database Health Checks 80Checks, Failures, and Repairs 81Types of Health Monitor Checks 81Manual Checks 82Data Recovery Advisor 88Managing the Data Recovery Advisor Through RMAN 89SQL Test Case Builder 96Improvements in Handling Data Corruption 96CHAPTER 3 Database Administration 99Database Automation 99Automatic Memory Management 100Automated Database Maintenance Tasks 105Flashback-Related New Features 110Total Recall and the Flashback Data Archive 111Flashback Transaction Backout 122Database Administration New Features 125Virtual Columns 125New Data Partitioning Schemes 128Allowing DDL Locks to Wait for DML Locks 128Explicit Locking of Tables 128Invisible Indexes 129Read-Only Tables 133Temporary Tablespace Management 133Creating an Initialization Parameter File from Memory 136Restore Point Enhancements 137Database Resident Connection Pooling 139Comparing and Converging Database Objects 143SQL*Plus New Features 147SQL*Plus Error Logging 147Default Settings in the SQL*Plus Executable 149Enhanced SQL*Plus BLOB Support 150Online Application Maintenance 150Support for New Objects 150Enhanced Online Index Creation and Rebuild 150Enhanced Default Column Value Functionality 151Online Reorganization of Materialized Views 152Minimal Invalidation of Dependent Objects 152Oracle Advanced Table Compression Option 153How the New Compression Feature Works 154Storage and Performance Gains 154Implementing OLTP Table Compression 154Compressing Unstructured Data 155Enterprise Manager New Features 156The Availability Tab 157The Server Tab 157New Related Links 158LogMiner Support 159Database Diagnostic Pack and Tuning Pack 160Oracle Scheduler New Features 161Lightweight Jobs 162Remote External Jobs 163Scheduler Support for Data Guard 165CHAPTER 4 Performance Management 167SQL and PL/SQL Performance Enhancements 168Automatic âNativeâ PL/SQL Compilation 168Faster DML Triggers 172Adaptive Cursor Sharing 172New Result Caching Functionality 175Using the Server Result Cache to Enhance Performance 175Managing the Query Result Cache 185PL/SQL Function Result Cache 186Intra Unit Inlining 190Automatic SQL Tuning 190Automation of SQL Tuning in Oracle Database 11g 191SQL Access Advisor Enhancements 194Optimizer and Statistics Collection Enhancements 197Multicolumn Statistics 197Expression Statistics for Functions and Expressions 201Changing Statistics Preferences 202Keeping Statistics Pending vs PublishingStatistics Immediately 203SQL Plan Management (SPM) 207ADDM Enhancements 214AWR Baselines 217Baseline Templates 219Adaptive Baseline Metric Thresholds 221Performance-Related Changes in Database Control 222Customized Performance Page 222Average Active Sessions 223ADDM Performance Analysis 223CHAPTER 5 Database Security 225Enterprise Database Security Concerns 225Stronger Password Hash Algorithm 226Security Out of the Box 226Delayed Failed Logins 229Case-Sensitive Passwords 230Basic Compliance with Industry Security Recommendations 230Upgrade Implications 231Password Versions 231Case-Sensitive Password Files 232Change Default User Passwords 232Database Links and Case Sensitivity 233Password Management 234Tablespace Encryption 239Creating the Oracle Wallet 240Wallet Requirements 241Encrypted Tablespace Caveats 242Encrypting a Tablespace 242Enterprise Manager Integration 244Transparent Data Encryption with Enterprise ManagerDatabase Console 245Tablespace Encryption with Database Console 245Policy Trend Overview 247Additional Security Management Integration inDatabase Console 248UTL_ Package Network Access Management 248Fine-Grained Access Control for UTL_* Network Packages 249sysasm Privilege for Automatic Storage Management 258LOB Encryption Enhancements 258Data Pump Encryption 258RMAN Virtual Private Catalog 258RMAN Backup Shredding 258TDE with LogMiner Support 258TDE with Data Guard SQL Apply 259Oracle Audit Vault 259TDE with Hardware Security Module Integration 259Oracle Advanced Security Features 260Kerberos Cross-Realm Support 261sysdba Strong Authentication 261Oracle Call Interface Enhancements 261Set the Level of Information Captured for Bad Packets 262Delay or Drop Database Connections 262Configure Maximum Number of Server Connection Attempts 263Control the Display of Database Release Information 263Set Up the Banner and Auditing for Unauthorized Access 264CHAPTER 6 Backup and Recovery 265Enhanced Block Media Recovery 265Preconditions for Using the recover ⦠block Command 266Using the recover ⦠block Command 267RMAN Management Enhancements 270Scripting with RMAN Substitution Variables 270New RMAN Configuration Parameters 273Backing Up Large Files in Sections 274Creating Archival (Long-Term) Backups 276The New Validate Command 281Configuring an Archived Redo Log Deletion Policy 285Archived Redo Log Failover 287Backup Shredding 288Optimized Backing Up of Undo Data 288Active (Network-Based) Database Duplication 288Prerequisites 289Necessary Spfile Modifications 290Performing Active Duplication 292How Network-Enabled Duplication Works 297Recovery Catalog Management 299Merging Recovery Catalogs 299Moving a Recovery Catalog to Another Database 302Virtual Private Catalogs 302Enhanced RMAN Integration with Data Guard 307Configuring RMAN Without a Database Connection 308Restoring a Backup Controlfile to a Standby Controlfile 309Resynchronizing the Recovery Catalog 310Backup File Accessibility Groups 310Block Change Tracking Support in Standby Databases 311CHAPTER 7 Data Pump 313API Enhancements 313Compression Enhancements 314Encryption 319Specifying Encryption 319Choosing an Encryption Mode 320Reusing a Dump File 322Remapping Data 323Remapping a Table 325Export and Import of Partitions 326Ignoring Errors 329External Tables Based on Data Pump 329Stored Procedure to Generate External Table Using aData Pump 331CHAPTER 8 Oracle Streams 337Synchronous Capture 338Restrictions on Synchronous Capture 338Configuring Synchronous Capture 339DBA Views for Synchronous Capture 341Combined Capture and Apply 342Requirements for Combined Capture and Apply 342Combined Capture and Apply Validation 343Performance Advisor 344Streams Advisor Admin Package 344Streams Topology 345Streams Topology Views 346DBMS_COMPARISON for âCompare and Repairâ 348DBMS_COMPARISON Requirements 348Supported Database Object Types 348Comparison 349Comparison Maintenance 350Rechecking a Prior Comparison 351Converging Shared Database Objects (Repair) 352Splitting and Merging of a Destination 354Splitting a Stream 354Merging the Streams 354Merge Streams Job 355Usability Improvements 355Message Tracking 355Automated Alerts for Clients and Thresholds 356Identifying Newly Supported Tables View 357Identifying Minimum Required Checkpoint SCN 357Background Process Name Changes 357Support for XMLType Values Stored As CLOBs 358Support for Transparent Data Encryption 358Support for Oracle Scheduler 359CHAPTER 9 Storage Management 361Automated Storage Management 361Misconceptions of ASM 362RMAN and ASM 362sysasm Privilege and osasm Group 363Fast Rebalance 366ASM Upgrade 366Upgrading Manually 366Upgrading Using DBUA 367Rolling Upgrades 371ASM Preferred Reads 374Preferred Read Setup 374Monitoring Preferred Reads 375ASM Restricted Mode 376Diskgroup Attributes 381Allocation Unit (AU) Sizes 385RDBMS and ASM Compatibility 386Fast Mirror Resync 389asmcmd Commands 395ls 395lsdg 395lsct 396lsdsk 396cp 398Metadata Backup and Restore 400Backup Diskgroup Using md_backup 400Restore Diskgroup Using md_restore 401Metadata Backup and Restore Demonstration 402Additional md_restore Examples 409Bad Block Recovery with ASMCMD 409Oracle Direct NFS 410Set Up Direct NFS 410Validate Direct NFS 412Disable Direct NFS 413Network Interface Card Bonding 413Direct NFS Performance 413CHAPTER 10 Data Guard 415Active Physical Standby Database Duplication 416Real-Time Query Standby 418Start the Real-Time Query Standby 419Validate the Real-Time Query Standby Database 419Design the Real-Time Query Database 421Snapshot Standby 421Convert to Snapshot Standby 422Convert Back to Physical Standby 425Using the Physical Standby for Rolling Upgrades 426Prepare the Primary Database 426Convert to Logical: Keep Your Identity 427Improvements in Redo Transport 428Block Change Tracking Support 428RMAN Understands Data Guard Configurations 429Improved Integration with RMAN 429Compressed Redo Traffic 429Usage of Histograms for the NET_TIMEOUT Attributes 430Fast-Start Failover for Maximum Performance Mode 432Logical Standby: SQL Apply 432Support for Transparent Data Encryption (TDE) 433Dynamically Set the Data Guard SQL Apply Parameters 434Support for VPD and FGA 435DBMS_SCHEDULER Support 435Logical Standby Archivelog Storage 436SQL Apply Event Messages 437Data Guard Broker 437Data Guard Broker Command-Line Interface 438Customize Fast-Start Failover Events 440Initiate Fast-Start Failover from Applications 441New Data Guard Manager Properties 442Detect Lost-Write Conditions Using a Physical Standby 443Support of Heterogeneous OS Data Guard Configuration 443Oracle Database 11g Data Guard Over StorageVendor Solutions 444CHAPTER 11 Application Development 445New PL/SQL Features 445CONTINUE Statement 445Sequences Without Dual 446Native Compilation 446SIMPLE_INTEGER 446Regular Expression Enhancements 449Named and Mixed Arguments in SQL Statement PL/SQLFunction Calls 451Subprogram Inlining 451Generalized Invocation 455Cross-Session PL/SQL Function Result Cache 458Bulk In-Bind Table of Records in FORALL 463Dynamic SQL Symmetry and New Functionality 465New Trigger Features 469Trigger Ordering: The FOLLOWS Clause 469Creating Triggers As ENABLED or DISABLED 469Compound Triggers Type 469XML DB Improvements 475Repository Events 475Support Content Repository API for Java: JSR-170 475ACL Security 475New XMLType 475XMLIndex 481Native Web Services for Oracle XML DB 493XQuery Enhancements 500XML Developerâs Kit (XDK) Improvements 502Application Express (APEX) Enhancements 505APEX Configuration 505APEX Enhancements 506PHP Support Enhancements 507Java Enhancements 508Just-in-Time (JIT) Compiler and Native Compilation 508JAR Support 508Improvements to the loadjava Tool 510Improvements to the dropjava Tool 510Improvements to the ojvmjava Tool 511The ojvmtc Tool 512CHAPTER 12 Data Warehousing 515Next-Generation LOBs 516SecureFiles Requirements 516BasicFiles vs SecureFiles 516LOB Performance 517Deduplication 518DBMS_LOB.SETOPTIONS 522Encryption 522Compression 523db_securefile Initialization Parameter 525Migrate from BasicFiles to SecureFiles 526LOB Prefetch 527Data Warehousing New Features 527Partition Change Tracking 528Materialized View Refresh Performance Improvements 529Materialized View QUERY REWRITE Enhancements 530Pivot Operators 532Unpivot Operators 537Partitioning 538Partition Advisor 539Reference Partitions 544Interval Partitioning 546Extended Composite Partitioning 552Virtual Column-Based Partitioning 556System Partitioning 559Enhanced Partition Pruning Capabilities 561Oracle Multimedia 561Enhanced DICOM Support 561ORDDICOM Object Type 562Image Processing 562Support for SecureFiles 562Additional Multimedia Enhancements 563INDEX 565