Oracle Enterprise Manager Database Management capabilities make DBA lives easier by providing a full-lifecycle solution encompassing change and configuration management, patching, provisioning, testing, masking/subsetting, performance management and automatic tuning. Increase DBA productivity by 80% and reduce database testing time by 90%. Oracle revolutionized the field of enterprise database management systems with the release of Oracle Database 10g by introducing the industry’s first self-management capabilities built right into the database kernel. Today, after several releases and continuous improvement of this intelligent management infrastructure, Oracle Enterprise Manager Database Management provides the most extensive self-management capabilities in the industry, ranging from zero-overhead instrumentation to integrated self-healing and business-driven management. Oracle’s Database management includes the following Key Features.

Performance management using Automatic Workload Repository (AWR), AWR Warehouse, Automatic Database Diagnostics Monitor (ADDM), AWR Baselines and Adaptive Thresholds, ASH Analytics. Application Tuning using SQL Tuning Advisor, SQL Access Advisor, Real Time SQL Monitoring, Database Operations Monitoring. Response Time Testing using SQL Performance Analyzer, SPA Quick Check. Throughput Testing using Database Replay. Oracle Enterprise Manager Cloud Control is a single pane of glass tool that provides monitoring and managing solution for all types of services, such as database, middleware, infrastructure and hardware based, running on on-premise, Oracle Cloud, and Oracle Cloud Machine deployments. Oracle Tuning Pack for Oracle Database offers an extremely cost-effective and easy-to-use solution that automates the entire application tuning process.

[embedyt] https://www.youtube.com/watch?v=f-ywB25TMhA%5B/embedyt%5D

Oracle Enterprise Manager Database Management

For database administrators and application developers, application tuning is a critically important area and a considerable amount of their time is spent performing this very important function. A poorly tuned business application can potentially affect not just a few users but an entire business operation and for this reason companies invest significant resources to ensure smooth running of applications vital for their businesses. However database administrators and developers often use handcrafted scripts to address application performance issues. Although these scripts may resolve the symptoms manifested by the issue but it seldom addresses the root cause of a performance problem. The script based approach has other inherent shortcomings. It is neither scalable nor does it stand the test of time as newer versions of the Oracle Database are released. As the number of databases in an organization increases the management of scripts becomes very tedious and error prone.

SQL And Database Operations Monitoring

The first step in SQL tuning is identifying a poor SQL that is consuming excessive system resources. Real-Time SQL Monitoring, introduced in Oracle Database 11g, provided a very efficient way to identify and fix performance problems with long running SQL and PL/SQL statements. Any SQL statement running in parallel or consuming at least 5 seconds of CPU or I/O time in a single execution is automatically monitored. Key performance metrics, including the elapsed time, CPU time, number of reads and writes, I/O wait time and various other wait times are automatically captured. But the ability to monitor a combination of SQL and PL/SQL running in a single session was not available. Real-Time Database Operations Monitoring, a new feature in Oracle Database 12c, combines the capability to monitor both SQL and PL/SQL and allows an administrator to monitor long running database tasks such as batch jobs, ETLs etc. as a composite business operation.
Oracle Enterprise Manager Database Management
[TABS_B id=19159]