Key DB monitoring enhancements.
Oracle EM team has made some significant modifications to the Database Home page in Oracle 12c. The homepage has been divided into regions that can be personalized based on the requirement of the users. The performance region allows the administrator to quickly gauge system resource utilization by wait classes or by various database services. The Monitored SQL region gives a snapshot of all queries currently executing and can be very useful to identify long running queries. One metric is “SQL Monitor – Last Hour” that provides exhaustive details on sqls ran in past hour.
This is one of the popular buzz words in 12c. A new tool to explore the ASH data that allows the administrator to rollup, drill-down, and slice or dice performance data across various performance dimensions. With the ability to create filters on various dimensions, identifying performance issues has never been easier. The built‐in Treemap view allows administrators to explore performance data using predefined performance dimension hierarchies.
Even though Real‐Time SQL Monitoring introduced in Oracle Database 11g provides the fastest and easiest way to identify and fix performance problems with long running SQL statements. Live visual displays track the details of SQL execution using new, fine‐grained SQL statistics that are updated automatically at no cost to the performance of production systems. This feature is immensely useful for the performance tuning DBAs.
Real‐Time ADDM is an innovative way to analyze problems in extremely slow or hung databases. Real‐Time ADDM runs through a set of predefined criteria to analyze the current performance and helps the DBA to resolve deadlocks, hangs, shared pool contentions and many other exception situations which force the administrator to bounce their databases today.
Secure Test Data Management in Oracle Enterprise Manager Cloud Control 12c. Oracle Enterprise Manager Cloud Control 12.1 has several test data management capabilities, such as application data models, data subsetting and data masking. To be able to take advantage of these capabilities, each database involved in the test data management process must have the necessary library functions deployed onto the database.
When a new application has been provided to the application users, it can be a daunting task to construct the application relationships that make up the application. Fortunately, the process of creating the application data model has been greatly simplified for application schema where the application relationships are enforced through database constraint.
Monitor health of Fusion Middleware
As Oracle technologies are aggressively transforming into Fusion, an integral part of your daily administrator duties is to ensure that your Oracle Fusion Middleware and WebLogic deployments are up and performing as expected. In addition, it is also important to understand relationships between components of the farm/domain in order to understand the impact of problems either upstream or downstream from the problematic component. Having such data easily and quickly available is critical to efficiently managing your Oracle Fusion Middleware software.
Composite Application Management
In complex datacenter environments administrators need a single window view of top level metrics/information related to critical SLA of business services, application performance which expose the business services, critical business metrics exposed by applications, and performance of application stack components. This allows administrators to save times as they may have to visit several performance pages and consoles to get high level perspective of their environment. Some business applications such as EBS expose critical business metrics e.g. Number of Orders. In such cases dashboards become even more important as they allow administrators to bridge the gap between business metrics and system metrics. Also, requirements of every business, data center are different. In such scenario obviously Administrator would require an ability to customize dashboard and select appropriate performance metrics from various source. When you look at the dashboard for your new Composite Application, you can see all the members, service levels, incidents, JVM health, and whatever other type of metrics that you like such as the request Processing Time.
Middleware Diagnostic Advisor
12c EM helps Administrator with valuable information rather than just bunch of ‘performance metrics’. This information is given in terms of ‘findings’ on WebLogic server. These performance findings are generated based on variety of performance metrics from EM’s End‐to‐End diagnostic solution and various rules that will determine the root cause of the issue. This proactive root‐cause‐analysis helps Administrator save valuable time when it comes to identifying performance bottlenecks in production applications.
You can learn more about 12c’s capabilities in http://www.oracle.com/technetwork/oem/pdf/512044.pdf
How to Install Enterprise Manager Cloud Control 18.104.22.168 (12c) [ID 1359176.1]
EM 12c: How to Install EM 12c Agent using Silent Install Method with Response File [ID 1360083.1]
Enterprise Manager Cloud Control 12c Installation – List of the Log Files and Commands to Zip them into One Zip Archive [ID 1363779.1]
Thanks to Oracle EM development team for the product and as well as for some key contents.