|
Introduction to 11g New Features for developers
Inside
11g New Features
OEM - Enterprise Manager Oracle 11g new
features
Oracle 11g New Features Programming Language Support
Oracle 11g PL/SQL New Features
Oracle SQL optimizer (CBO) Improvements
Oracle 11g SQL New Features
HTML-DB 11g
Enhancements
Oracle 11g Business Intelligence
& OLAP
Oracle 11g data
mining
OEM Oracle 11g new features
Introduction to OEM
Improved Database Home Page and Performance changes Integrated
Interface for LogMiner
Advanced Replication Interface
Wait Activity Detail Enhancement
Easy Oracle Text Management
Better OEM Grid
Tools
Clone Database Enhancements
Migrate Database (and more!) to ASM
Workspace
Manager
Find
Referential Integrity Constraints
Compress a
Workspace
Manage System Parameters
Privilege Management
Conclusion
Oracle 11g PL/SQL New Features
11g PL/SQL New
Features
PL/SQL Sequence Access
SIMPLE Number Types
The CONTINUE Statement
PL/SQL Subprogram Inlining
PL/SQL Compound Triggers
PL/SQL Trigger Enhancements
Cross-Session PL/SQL Function
Result Cache
Conclusion
Oracle 11g SQL New Features
11g SQL
SQL PIVOT and UNPIVOT Operators
Regular
Expressions Enhancements
regexp_instr
regexp_substr
regexp_count
Result Cache Hint
HASH OUTER JOINS
Conclusion
11g Performance Tuning Features
New
Performance Tuning Features
A trip to the SPA – Inside the 11g SQL Performance Analyzer
Decision Support and Expert Systems Technology
Inside the Oracle 11g SQL Performance Analyzer
A trip to the SPA
Comparing the SPA
Results
Extended Optimizer
Statistics
Inside Extended
Optimizer Statistics
Automatic
Diagnostic Repository
Conclusion
Oracle 11g Security Enhancements
New Password Security Features
Enhances hashing algorithm
Passwords with symbols in 11g
Case sensitive passwords
Case sensitive passwords and database upgrade to 11g
How to enable the Oracle 11g EXCLUSIVE MODE
Enforcing complex passwords
How to
find accounts with default passwords in 11g
Other
Hacking Prevention Features
Auditing by DEFAULT in 11g
Strong Authentication for SYSDBA and SYSOPER in 11g
Limiting Access to External Networking Services
How to create and manage ACLs with PL/SQL
How to create and manage
ACLs with OEM
Other network security
features
Transparent Data Encryption Features in 11g
External Master Key Storage using Hardware Security Module
TDE with
Logminer and Logical Standby Database
TDE with
Export Data Pump
Transparent Tablespace Encryption
TDE with Enterprise Manager
Intelligent LOB Encryption with Secure File LOBs
Securefile Lobs at work
Securefile
Lobs at work with OEM
Virtual Private Catalogues for RMAN
Other security aspects about backup in 11g
Conclusion
Oracle 11g Change Management
RAT - Real
Application Testing
Testing with a snapshot standby
database
SQL Performance
Analyzer (SPA)
SQL Performance Analyzer using PL/SQL
SQL Performance Analyzer using OEM
Database Replay
Database replay using the command line
Preparing the system for capture
Capturing the workload
How to capture a workload in a 10g database for replay in an 11g database (patchset
10.2.0.4)
Preparing the testing system for workload replay
Workload replay and analysis on the testing system
Database replay in the GUI
Conclusion
SQL Management
SQL Plan Management with SQL
Plan Baselines
How Automatic SQL
Plan Management works
Use cases for Automatic SQL Plan Management
SQL Plan Management in OEM
How Manual SQL Plan Loading works
Integration of SQL Plan Management with Automatic SQL Tuning
Conclusion
Oracle 11g Flashback
A brief history of FLASHBACK
functionalities
TRANSACTION BACKOUT in Oracle 11g
Transaction backout without OEM using PL/SQL
Transaction backout with OEM
Oracle Total Recall
The Technology Behind It
Enabling Flashback Data Archive
What is in the Flashback Data Archive?
DDL limitations for Flashback
Data Archive
What’s new about UNDO and
transactions in 11g?
Optimized UNDO BACKUP with RMAN
Conclusion
|
