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