Published on February 28, 2014
By Francisco Munoz Alvarez Oracle 11G New Functionalities for DBAs
OK,are you from?
Born here Grow up here Got Married Here Mature here Now Living here
ORACLE 11G IMPROVEMENTS
STREAMS 30%-50% Faster RAC 70% Faster Optimizer Stats Collection 10X Faster More Details More Improvements Query Results Caching 25% Faster
Table Scans 2.5 X Faster using Advance Compression Need More? More Improvements Oracle Secure Files 5X Faster than normal filesystems.
“it enables read-only access to a physical standby database for queries, sorting, reporting, webbased access, while continuously keep applying all changes received from the primary database.” ACTIVE DATA GUARD 11G NEW FUNCTIONALITIES
“Compresses any type of data (structured and unstructured data), as well as network traffic, memory utilization and inclusive the amount of data in the process of being backed up” ADVANCED COMPRESSION 11G NEW FUNCTIONALITIES
• • • • • • OLTP compression – It allows structured and unstructured data to be compressed on INSERT, UPDATE and DELETE operations. RMAN Backup Compression - Compress RMAN backups. Datapump export compression - Compress datapump export files. SecureFiles Deduplication - Detect and eliminate duplicate copies of files stored within the database. SecureFiles Compression - Compress unstructured file data within the database. Network Traffic Compression - Compress Data Guard redo data as it is sent over the network. Compressions Available 11G NEW FUNCTIONALITIES
OLTP Compression When Loading Data
OLTP Compression When Reading
OLTP Compression When Inserting (Part II)
ADVANCED COMPRESSION 11G NEW FUNCTIONALITIES
“allows businesses to quickly adopt new technologies while eliminating the risks associated with any change “ “it combines a workload capture and replay feature with an SQL performance analyser to help you to test the changes against real-life workloads, then it will help you to fine-tune them before putting them into production” RAT Real Application Testing
“ Indexes that are ignored by the optimizer. Handy for testing without dropping “ INVISIBLE INDEXES 11G NEW FUNCTIONALITIES
“Virtual Private Catalog and Import Catalog” “Recovery Advisor” RMAN> LIST FAILURE; RMAN> ADVISE FAILURE; RMAN> REPAIR FAILURE; <PREVIEW><NOPROMPT> RMAN What is New “Active Database Duplication”
“Multi Section Backups” “Tablespace Point in Time Recovery” “Duration” Backup duration 00:30 database; <minimize time> <minimize load> RMAN Some more cool stuff
“Validate Database” “Archival Backup” Any time this command detects a database failure, it initiates a failure assessment and logs the failure in the ADR. RMAN “Backup Failover to Non-Flash Recovery Areas” Some more stuff
“ Configure the DB_ULTRA_SAFE initialization parameter on both the primary and standby systems for the most comprehensive data corruption prevention and detection.“ DB_ULTRA_SAFE 11G NEW FUNCTIONALITIES
DB_ULTRA_SAFE In the Primary DB
DB_ULTRA_SAFE In the Standby
“Read Only Tables” “Health Monitor” “Virtual Columns” “Edition Based Redefinition” purely expression-based and aren't stored on-disk Enables you to upgrade the database component of an application while it is in use, thereby minimizing or eliminating down time. Other Important Stuff In Oracle 11G
Blah! Blah! Blah! Blah! Blah! Blah! Blah! Blah! Blah! Blah!
RMAN New Features and Enhancements ... introduced with Oracle Database 11g in the backup and recovery area. In this version
What's New in Backup and Recovery? ... Recovery features are new in Oracle Database 11g ... enhancement is helpful when it is not ...
Advanced Oracle Tips and Tricks for the Oracle DBA: ... Oracle 11g: Backup and Recovery (RMAN) New Features ... New Features for Oracle 11g: ASM enhancements.
... (RMAN) Enhancements in Oracle Database 11g Release 1. ... Backup and Recovery Enhancements in Oracle Enterprise ... What's New in Backup and Recovery?
Oracle Database 11g Backup and Recovery Technologies An Oracle White Paper December 2008
Oracle Database 11g Release 2: New Features Overview Seminar NEW ... include new features in grid ... Backup and Recovery Enhancements Describe new SET ...
Backup And Recovery - Oracle 11g ... Oracle backup and recovery tool.The following are the key new features and enhancements in the backup and ...
Oracle Database 11g: New Features Overview ... Parallel Backup and Restore for Very Large Files ... RMAN Data Recovery Commands RMAN Security Enhancements
Application Maintenance and Upgrade Enhancements; Backup and Recovery Enhancements; Flashback Technology, ... Oracle Database 11g: New Features for ...