際際滷

際際滷Share a Scribd company logo

Upgrading Oracle 9i To Oracle 11g

F
Farooq Hussain

The document discusses the benefits of upgrading an Oracle 9i database to Oracle 11g. Some key improvements in 11g include enhanced scalability, reliability, and manageability. New features such as the web-based Enterprise Manager, Automatic Database Diagnostic Monitor, Active Data Guard, and Automatic Memory Management provide improved performance, availability, and ease of administration over the older Oracle 9i database system. Upgrading allows companies to take advantage of 11g's new capabilities while keeping their database infrastructure current to support growing business needs.

1 of 14
Upgrading Oracle 9i to Oracle 11g Farooq Hussain
The Big Question Why should I replace a database system that is completely stable for my companys needs ? Growing business demands calls for growing I.T demands Oracle databases need to keep up with newer applications New features means wider scope for the existing infrastructure Its Better, its Faster and its Stronger
Oracles latest database version Some features improved and some are completely new Improved scalability Improved reliability Improved manageability Whats new with Oracle 11g
Improvements in 11g
Improvements in 11g Enterprise Manager Shifted from heavy Java based application to light Web based version One single screen shows the overall database status Self-tuning database Automatic Database Diagnostic Monitor (ADDM) Backup and Recovery Options
Improvements in 11g Enterprise Manager 9i Enterprise Manager 11g
Improvements in 11g Data Guard Carrying over from 9i with some new changes Active Standby Database
Improvements in 11g Prior to 11g No Active Standby Primary Database Server Standby Database Server Open READ ONLY Shipping of archive logs Unable to apply Archive Logs Oracle 11g Active Standby Primary Database Server Standby Database Server Open READ ONLY Shipping of archive logs Archive Log Application
Improvements in 11g Real Application Clusters First version of RAC had issues Rolling Patch Upgrades ADDM for RAC Provisioning Pack for RAC
The New Features
The New Features Database Replay Like a recording device in the database It captures the workload not just SQL and replays it Simple configuration with advanced results
The New Features SQL Performance Analyzer Similar to Replay but different Extension of SQL Tuning Shows you the before and after picture Part of Real Application Testing with Database Replay
The New Features Automatic Memory Management Carried over from 10g Automatic SGA management Sets the memory parameter once for SGA and PGA Eliminates restriction on server memory to the database
Thank You !

More Related Content

Upgrading Oracle 9i To Oracle 11g

  • 1. Upgrading Oracle 9i to Oracle 11g Farooq Hussain
  • 2. The Big Question Why should I replace a database system that is completely stable for my companys needs ? Growing business demands calls for growing I.T demands Oracle databases need to keep up with newer applications New features means wider scope for the existing infrastructure Its Better, its Faster and its Stronger
  • 3. Oracles latest database version Some features improved and some are completely new Improved scalability Improved reliability Improved manageability Whats new with Oracle 11g
  • 5. Improvements in 11g Enterprise Manager Shifted from heavy Java based application to light Web based version One single screen shows the overall database status Self-tuning database Automatic Database Diagnostic Monitor (ADDM) Backup and Recovery Options
  • 6. Improvements in 11g Enterprise Manager 9i Enterprise Manager 11g
  • 7. Improvements in 11g Data Guard Carrying over from 9i with some new changes Active Standby Database
  • 8. Improvements in 11g Prior to 11g No Active Standby Primary Database Server Standby Database Server Open READ ONLY Shipping of archive logs Unable to apply Archive Logs Oracle 11g Active Standby Primary Database Server Standby Database Server Open READ ONLY Shipping of archive logs Archive Log Application
  • 9. Improvements in 11g Real Application Clusters First version of RAC had issues Rolling Patch Upgrades ADDM for RAC Provisioning Pack for RAC
  • 11. The New Features Database Replay Like a recording device in the database It captures the workload not just SQL and replays it Simple configuration with advanced results
  • 12. The New Features SQL Performance Analyzer Similar to Replay but different Extension of SQL Tuning Shows you the before and after picture Part of Real Application Testing with Database Replay
  • 13. The New Features Automatic Memory Management Carried over from 10g Automatic SGA management Sets the memory parameter once for SGA and PGA Eliminates restriction on server memory to the database