Manageability Value Propositions
- Lower Management Costs
- Largest line item in TCO is management cost – not license cost
- Costs increasing with growth in system complexity and size
- Self-managing systems significantly lower managements costs
- Increase System Availability
- System unavailability no longer an option
- Unplanned down-time must be minimized/eliminated
- Eliminate Human Error – # 1 cause of unplanned down-time
- Meet/Exceed Service Level Agreements (SLA’s)
- System performance impacts business productivity
- Business must meet their SLA’s
- Deliver reliable and predictable performance by proactive auto-tune
Problem: Managing High Response-Time SQLs
- Monitoring: tracking high response-time SQL
- What is that expensive SQL (ETL, DDL, batch, report, …) I started up to?
- Do I have any high response-time SQL running on my OLTP system?
- Any SQL executing parallel?
- Investigating: why is this execution so expensive?
- Plan has hundreds of operations — where is the time being spent?
- Why is a particular operation so expensive?
- SQL runs parallel, is DOP appropriate? is there a skew?
- What is going on inside a SQL execution???
Solution: Real-time SQL Monitoring
- Shows what’s happening inside SQL execution
- Automatically monitors long running SQL
- Enabled out-of-the-box with no performance impact
- Monitors each SQL execution
- Exposes monitoring statistics
- Global execution level
- Plan operation level
- Parallel Execution level
© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.
相关文章 | Related posts:
- Oracle Support Diagnostics Tools
- Advanced Compression in Oracle Database 11g
- gc lost blocks diagnostics
- Hash Joins Implementation and Tuning
- Lower Storage Costs by 10x with Oracle Database 11g
- Competing Against Microsoft SQL Server 2008 with Oracle Database 11g
- Enterprise Manager 11g Technical Previews
- Oracle Database 11g: New Features Overview eStudy Student Guide
- Oracle Text – Performance and Tuning
- Automatic Checkpoint Tuning
最新评论