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