databse & technology 2 _ francisco munoz alvarez _ 11g new functionalities for dba.pdf
DESCRIPTION
TRANSCRIPT
By Francisco Munoz Alvarez
Oracle 11G New Func)onali)es for DBAs
OK,are you from?
Born here Grow up here
Got Married Here Mature here Now Living here
ORACLE 11G IMPROVEMENTS
RAC 70% Faster
Query Results Caching
25% Faster
More Details More Improvements
STREAMS 30%-‐50% Faster
OpEmizer Stats CollecEon 10X Faster
Oracle Secure Files 5X Faster than normal
filesystems.
Table Scans 2.5 X Faster using
Advance Compression
Need More? More Improvements
“it enables read-‐only access to a physical standby database for
queries, sor)ng, repor)ng, web-‐based access, while con)nuously 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 u)liza)on 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 opera)ons.
• RMAN Backup Compression -‐ Compress RMAN backups. • Datapump export compression -‐ Compress datapump export
files. • SecureFiles Deduplica?on -‐ 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 Inser)ng (Part II)
ADVANCED COMPRESSION 11G NEW FUNCTIONALITIES
“allows businesses to quickly adopt new technologies while
elimina)ng the risks associated with any change “
RAT Real Applica)on Tes)ng
“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 pu\ng them
into produc)on”
“ Indexes that are ignored by the optimizer. Handy for testing without
dropping “
INVISIBLE INDEXES 11G NEW FUNCTIONALITIES
“AcEve Database DuplicaEon”
“Virtual Private Catalog and Import Catalog”
“Recovery Advisor”
RMAN> LIST FAILURE; RMAN> ADVISE FAILURE; RMAN> REPAIR FAILURE;
<PREVIEW><NOPROMPT>
RMAN What is New
“Tablespace Point in Time Recovery”
“MulE SecEon Backups”
“DuraEon”
Backup duraEon 00:30 database; <minimize Eme> <minimize load>
RMAN Some more cool stuff
“Backup Failover to Non-‐Flash Recovery
Areas” “Archival Backup”
“Validate Database”
Any Eme this command detects a database failure, it iniEates a failure assessment and logs the
failure in the ADR.
RMAN Some more stuff
“ Configure the DB_ULTRA_SAFE ini)aliza)on parameter on both the primary and standby systems for the most comprehensive data corrup)on
preven)on and detec)on.“
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”
purely expression-‐based and aren't stored on-‐disk
“EdiEon Based RedefiniEon”
Enables you to upgrade the database component of an applica)on while it is in use,
thereby minimizing or elimina)ng down )me.
Other Important Stuff In Oracle 11G
Blah! Blah!
Blah! Blah! Blah!
Blah! Blah!
Blah! Blah! Blah!
Thank You!