250 likes | 421 Views
Technology Day. Business drivers for 10g Migration. Compliance & Standards. SOX, PCI, HIPPA Implement database standards / procedures company wide Leverage Configuration Management Pack. Productivity. OEM / Grid Control (70 instances / single management console)
E N D
Technology Day Business drivers for 10g Migration
Compliance & Standards • SOX, PCI, HIPPA • Implement database • standards / procedures company wide • Leverage Configuration • Management Pack
Productivity • OEM / Grid Control • (70 instances / single management console) • Increase databases not DBA’s • Better manage effectiveness
Cost Reduction • Configure ASM to address any • storage sub system • Reduce the need to over provision • Maximize storage utilization
Improve Service Levels • Increase uptime • Centralize all recovery related files • Advanced Features reduce • database outages
Getting “Buy In” • Increased availability & reliability • Improved functionality • Remove the need for extended support • Application support, lower • quality of service
Kerry’s and Randy’s Top 10 List Reasons why you should upgrade to 10g
1. You’ll get fired if you don’t Well maybe not, but your boss won’t be happy if she starts having to pay extended support fees next summer. Seat of the Pants Chart
2. Looks good on your resume If you don’t get it done by next summer you’ll need your resume to be spiffed up. Seriously, learning 10g is a good thing for the Oracle professionals at your shop.
3. New Security Features PCI, SOX, etc… Transparent Data Encryption Password Policy Management Protection from DBA’s Encryption of Backups Etc…
4. RAC RAC works a lot better on 10g than it did on 9i.
5. Grid Control Visibility into all environments Centralized Repository Job Scheduling Monitoring / Alerting RMAN integration Data Guard Integration Extensibility – plug-ins, custom alerting Policy Management Configuration Management – patch notification
6. ASM Automatic Storage Management Used extensively in RAC environments Provides lots of benefits to single instances Better use of resources Much easier to manage Dynamic rebalancing
7. Flash Flash Back Query Flash Back Database Flash Recovery Area
8. RMAN block change tracking compression integration with Grid Control
9. Automatic Workload Repository (AWR) Active Session History (ASH) AWRRPT – replacement for statspack Repository can be used for custom reporting
Enterprise Capacity Planning 6 month history + 6 month forecast
Server Capacity Planning 6 month history + 6 month forecast
Database Capacity Planning 6 month history + 6 month forecast
10. It’s Free Actually you’ve already paid for it through your support fees. 3,000 man-years of development???
Caveats Self Managing (slightly heavier footprint) Fairly Significant Optimizer Changes Testing Applications is Key Success Factor Be aware of new out of the box functionality
Questions kerry.osborne@enkitec.com randy.johnson@enkitec.com