Sumário Itens Encontrados: 2701 Oracle Database 11g Getting Started 1Installing Oracle Database 11g 2The Database Configuration Assistant 4Upgrading to Oracle Database 11g 4Saving Time When Upgrading 5Supported Upgrade Paths 8Supported Upgrade Methods 9Upgrade with DBUA 9Manual Upgrades 17Using Export/Import for Upgrades and Rollback 23Upgrade Using Data Copying 25Oracle Parameter Changes 25New Parameters 25Deprecated Parameters 27Obsolete Parameters 28Undo_Management Parameter Madness 28Oracle Dictionary View Changes 28End of Line 292 Oracle Database New Management Features 31ASM-Related Changes and New Features 32New ASM-Related Documentation 33ASM Disk Group Attributes 33ASM Fast Disk Resync 34ASM Compatibility Settings 35ASM Preferred Mirror Read 36ASM Rolling Upgrades 37For more information about this title, click herevi Oracle Database 11g New FeaturesASM Support for Variable Allocation Unit Sizes 38New SYSASM Role 38New asmcmd Commands 40Automatic Memory Management 42Overview of Automatic Memory Management 42New Memory Advisor Functionality and Views 45How Is Oracle Managing My Memory? 46Automatic Memory Management and OEM 47Converting to Automatic Memory Management 48ADDM New Features 48ADDM New Views 48ADDM Now RAC-Aware 49Managing ADDM Through DBMS_ADDM 50Finding Classifications 52Directives 53AWR New Features 55Default Retention of AWR Snapshots Changed 55AWR Baseline New Features 55Adaptive Metric Thresholds 59Scheduler AutoTask Automated Maintenance Tasks 60AutoTask Architecture 60AutoTask Dictionary Views 61Managing AutoTask Tasks via OEM 64Managing AutoTask Tasks Manually 65AutoTask Maintenance Windows 67Parameter File Management Changes and New Features 69Read/Write Error Handling of SPFILES 69Easier Conversion to the Use of SPFILES 69Users Are Prevented from Setting Invalid Values in SPFILES 70Resource Manager Changes and New Features 70IO Calibration 70Default Maintenance Plan 72Built-In Resource Plans 73Resource Manager Statistics in AWR 74Resource Manager Plan Directive New Features 74Finer-Grained Dependencies 76DDL WAIT Option Now Default 77New Add Column Functionality 78End of Line 793 Oracle Database New Availability and Recovery Features 81Fault Diagnosability Infrastructure 82The Automatic Diagnostic Repository (ADR) 82The Alert Log 84Trace, Dump, and Core Files 85The Support Workbench 85RMAN New Features 99Interfile Backup Parallelism 100Faster Backup Compression 102Active Database Duplication 102Improved Handling of Long-Term Backups 106Backup Failover for Archived Redo Logs 107Archived Redo Log Deletion Policy Enhancements 107Recovery Catalog Enhancements 107Undo Backup Optimization 109Block Media Recovery Performance Improved 109Other RMAN New Features 109Oracle Flashback-Related New Features 110Oracle Flashback Transaction Backout 111Oracle Flashback Data Archives 114Oracle Standby Database New Features 119Lost-Write Detection 119Compression of Archived Redo Logs 120Real-Time Query Capabilities from a Physical Standby Database 120Snapshot Databases 120Oracle Data Pump New Features 121Exp Utility Deprecated 122Compression of Dump File Sets 122Data Pump Encryption Enhancements 123Data Pump Data Remapping (Obfuscation) 123Data Pump Rename Table 125Data Pump and Partitioned Tables 125Overwrite Dump Files 125Data Pump Data_Options Parameter 125The Transportable Parameter 126End of Line 1264 Oracle Database Advisors 127The Data Recovery Advisor 128The SQL Repair Advisor 139The SQL Access Advisor 140The Streams Performance Advisor 146Oracle Database 10g Database Advisor Views 147End of Line 1485 Oracle Database Change Management 149Database Replay 150Using Oracle Database Replay 150Database ReplayâOverview 151Database Replay Workload Support and Limitations 152Database ReplayâCapture Workload 153Database ReplayâPreProcess the Captured Workload 165Database ReplayâReplay Workload 168The SQL Performance Analyzer 181Overview of SQL Performance Analyzer 181SQL Performance Analyzer via OEM 181SQL Performance Analyzer via PL/SQL 188End of Line 1946 Oracle Database 11g Security 195Auditing 196Password-Related Features 197Password Settings and the Default Profile 197Password Complexity 198Password Case Sensitivity 199Hacking Prevention with Failed Logon Delays 199Password Hashing Changes 201Default Password Use 201Fine-Grained Access Control on Network Services 202Create the ACL and Define the Associated Privileges 202Assign the ACL to Network Hosts 203ACL-Related Data Dictionary Views 204Tablespace Encryption 204Overview of Oracle Tablespace Encryption 204Preparing the Database for Tablespace Encryption 205Creating Encrypted Tablespaces 207Encryption and Database Performance 208TDE and Log Miner, Logical Standby, and Streams 209Oracle SECUREFILE LOBS 209End of Line 2107 Oracle Database BI and Data Warehousing New Features 211Partitioning 212Interval Partitioning 212Extended Composite Partitioning 217Reference Partitioning 218System Partitioning 220System-Managed Domain Indexes 221Virtual Columns 222About Virtual Columns 222Creating Tables with Virtual Columns 223Partitioning Tables with Virtual Columns 225Data Pump Single-Partition Imports 225Materialized Views and Query Rewrite 227Online Redefinition for Tables with Materialized View Logs 227Query Rewrite During Refresh 227Partition Change Tracking Refresh for Union All Mviews 227New and Enhanced Materialized View Catalog Views 227Query Rewrite Enhancements 229The Pivot and Unpivot Clauses 231The Pivot Clause 231The Unpivot Clause 234Table Compression 235End of Line 2388 Application Development 239SQL*Plus 240New set Commands 240Fast Application Notification Events in an RAC Database 241Online Application Maintenance and Upgrade 241New lock table Parameter 242Fewer Exclusive Locks Taken During Online Operations 242Invisible Indexes 242SQL 244Read-Only Tables 244SQL Query Result Cache 244Client Side Result Cache 249Regular Expression Enhancements 249Named and Mixed Notation from SQL 250PL/SQL 251Create Triggers as Enabled or Disabled 251Create Trigger Follows Clause 252Compound Triggers 253Inlining 256SIMPLE_INTEGER Datatype 257PL/SQL Function Result Cache 258Dynamic SQL 259Dynamic SQL and REF Cursors 259PLW 06009 Warning 260PL/SQL Sequence Enhancement 260PL/SQL Continue Statement 261End of Line 2629 Performance Tuning 263Enhanced Oracle Process Monitoring 264Statistics 266Pending and Published Statistics 266x Oracle Database 11g New FeaturesRecovering Previous Statistics 268Extended Statistics 269PL/SQL Native Compilation 276SQL Plan Management 277SQL Plan Management Overview 277Plan Capture 278Use of SQL Plan Baselines 280Querying SQL Plan Baselines 280Evolving SQL Plan Baselines 282Managing SQL Plan Baselines 283Automatic SQL Tuning 286Overview of Automatic SQL Tuning 286Automatic SQL Tuning with OEM 288Manage Automatic SQL Tuning Manually 291Manual Creation and Use of SQL Tuning Sets 296Create the Task 296Create the SQL Tuning Set 296Load the SQL Tuning Set 297Link the SQL Tuning Set and the Task 298Set Any Task Parameters 298Execute the Task 298Review the Results 299Intelligent Cursor Sharing (Bind-Aware Peeking) 300About Bind-Aware Peeking 300Bind-Aware Peeking Views 301Starting a System with Bind-Aware Peeking 301Temporary Tablespace Features 302Temporary Tablespace Shrink 302The DBA_TEMP_FREE_SPACE View 303Real-Time SQL Monitoring 303Real-Time SQL Monitoring Overview 303Real-Time SQL Monitoring Views 303Real-Time SQL Monitoring Report 304Control Real-Time SQL Monitoring 304Control the Use of OEM Management Packs 305End of Line 30510 Other New Features and Enhancements 307Real Application Clusters 308OCI Runtime Connection Load Balancing 308Using XA Transactions with RAC 309RAC Configuration Assistants 309Network Configuration Assistant (NetCA) 310Database Rolling Upgrade 310Parallel Execution Honors Service Placement 311Direct NFS 312XMLDB New Features 313Binary XML Storage 313Partitioning Support for XMP 318XQuery Enhancements 318Database Native Web Services 320XML DB Repository Enhancements 321XML Developers Kit 322Java 322Oracle JVM-Related Features 322Enhancements to Existing Utilities 325The ojvmtc Utility 326JDBC 4.0 Support 327JDK Support in Oracle Database 11g 328New Oracle Supplied Packages and Procedures 328A Arupâs Top Ten Features 331Arupâs Top Feature # 1: Database Replay 333Arupâs Top Feature # 2: SQL Performance Analyzer 334Arupâs Top Feature # 3: Partitioning 334Arupâs Top Feature # 4: Transparent Tablespace Encryption 336Arupâs Top Feature # 5: Flashback Data Archive 337Arupâs Top Feature # 6: SQL Plan Management 338Arupâs Top Feature # 7: Private Statistics 339Arupâs Top Feature # 8: More Concurrency 341Arupâs Top Feature # 9: Result Cache 342Arupâs Top Feature # 10: Better-Quality PL/SQL Code 343Index 345