Today we are unveiling a new release of Oracle Enterprise Manager and a new IT management strategy called “business-driven IT management.” This strategy is the driving force behind the development of a new breed of management solutions that can irradicate age-old IT challenges and empower IT to drive business value. EM 11g is the only product in the market today that delivers in-built capabilities to provide these benefits and we will spend the next few minutes describing its capabilities.
But why focus on business value? Because when your business stakeholders see directly how IT can drive higher agility, productivity and efficiency for business, you will be asked fewer questions when you need to invest more on IT. We are going to show you today how to manage your IT environment so that your business stakeholders can understand the value of your services and see clearly the return on their investments in IT.
Database automation and manageability starts inside the database and starting in the 9i release, Oracle has added instrumentation to the Oracle database to gather critical statistics on usage and workload. In 10g, Oracle has added a number of advisors which make recommendations to help resolve issues and increase manageability. There are also a number of auto-tuning features in 10g to make tuning simpler and faster.
Now, in 11g, there are even more auto tuning features for SQL tuning and schema and RAC and recoverability and replication.
Oracle has been making steady progress in increasing the manageability of the Oracle Database. This graph compares the amount of time and the number of steps required for typical operations in Oracle in the 9i, 10g, and 11g releases. 11g now take 26 percent less time and 31 percent fewer steps that its predecessor, 10g.
This is yet another reason to upgrade to the latest version of the database supported by your application.
Now, let’s look at some of the top challenges DBAs face in the area of performance management and lets break these down into to Performance Diagnostics and Application Tuning.
ADDM is a core part of the diagnostic infrastructure in the Oracle Database and it was introduced in Oracle 10g and it has further evolved in Oracle Database 11g. ADDM starts off with analysis of snapshots of key workload metrics taken in the Database. These snapshots include critical performance information pertaining to the database kernel and the database workload as well as at the operating system level. ADDM runs on a regular basis (by default once an hour) and it analyzes this information and makes recommendations on problems that it identifies.
For example, when there are SQL load issues, the SQL Advisors make recommendations on how to tune the SQL statements. Also when there are IO or CPU issues, ADDM gives advice on system resource optimization. And if you are running a RAC cluster, ADDM analyzes your complete RAC infrastructure including your interconnect and it offers advice there as well.
ADDM is part of the database kernel, so it is always up to date an in synch with your version of the database.
ADDM uses a Classification Tree methodology and it brings to your attention only those things which require your attention.
Global ASH report?
Enhanced ADDM:Shows blocking sessions across RAC nodes
Configuration wide view for RAC/HA setup instead of individual targets
Show Availability related events
Instant notifications on RAC Database/Instance Availability
Backup/Recovery
Standby
DB, Instance, ASM
HA Configuration standards
Report Best practice HA configuration standards
Workflows to implement using Enterprise Manager
Show key HA information
% Availability across configuration
Last Backup, Next Backup
FRA charts
Standby metrics, Red generation chart
Cluster Managed Services summary, and drilldowns
Launch HA Operations in context
Automatic SQL Tuning was introduced in 10g. In 11g, we have taken it to the next level.
High load SQL is captured from the kernel and passed to the Automatic Tuning Optimizer. It analyzes the SQL as well as the access structures (indexes, MVs) used by those SQL statements. Out of the ATO come various types of recommendations.
You may get SQL Tuning recommendation to create a SQL Profile which is especially useful with packaged application where you may not be able to wait for your vendor to change a SQL statement.
While tuning a SQL statement, SQL Tuning Advisor searches real-time and historical performance data for alternative execution plans for the statement. If plans other than the original plan exist, then SQL Tuning Advisor reports an alternative plan finding.
Sometimes SQL Tuning Advisor may recommend accepting a profile that uses the Automatic Degree of Parallelism (Auto DOP) feature. A parallel query profile is only recommended when the original plan is serial and when parallel execution can significantly reduce the elapsed time for a long-running query.
© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.
相关文章 | Related posts:
- Enterprise Manager 11g Technical Preview: Application Testing Suite 9.1
- Oracle Database 11g: Server Manageability Student Guide
- Deploying Oracle Enterprise Manager 11g Grid Control
- Oracle Enterprise Manager 10gr4 Diagnose and Tune Your Oracle Database Performance Problems Faster
- RAC Tuning Tips
- Oracle BI Enterprise Edition 11g Installation,Upgrade,Security
- No Time for Downtime Patching Database using Oracle Enterprise Manager
- 11g: Scheduler Maintenance Tasks or Autotasks
- Oracle Database 11gr1/10gr2 Automatic Storage Management Overview and Technical Best Practices
- Oracle Database 11g: Change Management Overview eStudy
最新评论