Database management

Oracle Enterprise Manager 13.5 unifies database management

Oracle today announced the availability of Oracle Enterprise Manager 13.5, bringing a series of new database management and analytics capabilities.

Oracle Enterprise Manager 13.5, also known as Oracle Enterprise Manager 13c Release 5, is the first major update to the management platform since January 2020, when version 13.4 became available. Oracle Enterprise Manager (EM) provides management, deployment, migration, and optimization capabilities for Oracle databases running on-premises, as well as in the cloud. Among the new features in the 13.5 update is an on-premises database migration tool to Oracle Cloud Infrastructure. The 13.5 update also provides a new Automatic Workload Analysis feature to optimize performance.

Among the many users of Oracle Enterprise Manager is Communications Test Design Inc. (CTDI) in West Chester, Pennsylvania. Naveen Garg, Senior Director of Database Administration at CTDI, explained that his organization has more than 100 operations centers around the world for repair and logistics. for IT customers. Applications supporting these branches have an Oracle back-end.

“Monitoring and managing these Oracle databases is critical to keeping our operations running smoothly, 24/7,” Garg said. “We rely on EM trigger alerts and also manage the Oracle fleet at CTDI.”

Oracle Enterprise Manager 13.5 includes an enterprise summary dashboard that gives administrators visibility into running databases.

Database optimization improvements

Garg said that of all the features in Oracle Enterprise Manager, the most valuable to him are the tuning and diagnostic capabilities.

“We look forward to the new and improved features around ASH [Active Session History analytics] and SQL advisors to help us keep our Oracle databases running smoothly,” said Garg.

Mughees Minhas, vice president of global database product management at Oracle, said Enterprise Manager 13.5 includes automatic workload analysis functionality. The feature continuously compares database performance, whether on-premises or in the cloud, against expected baseline performance. In the event of a performance discrepancy, Enterprise Manager will alert the database administrator and provide an overview of corrective actions.

Minhas said workload analysis can be configured for a specific threshold. For example, if performance degrades by 5%, Enterprise Manager can be configured to fix the underlying problem to bring performance back to baseline levels.

Monitoring and managing these Oracle databases is critical to keeping our operations running smoothly, 24/7.

Naveen GargSenior Manager, CTDI

Deeper insights into database operations

Oracle Enterprise Manager 13.5 also allows users to upload metrics and logs to Oracle Autonomous Data Warehouse for future analysis.

Minhas said that although Enterprise Manager has its own interface for viewing metrics, organizations want to be able to use other analytics tools for more complex analytics.

“Enterprise Manager has great insights into performance and configuration metrics,” Minhas said. “So if you really want to do analytics on it, you can actually pull the data out of Enterprise Manager, put it in an autonomous data warehouse and then you can do whatever analytics you want for forecasting, capacity planning or performance planning.”

Cloud and on-premises database management features

According to MinhasOracle Enterprise Manager 13.5 enhances previous releases with native integration to Oracle’s cloud.

Enterprise Manager now understands the different configuration and operational settings between on-premises and cloud database deployments. The goal is to enable organizations to manage all Oracle database deployments, whether in the cloud or on-premises with a single platform.

“This awareness really makes it much more transparent to manage your hybrid cloud fleet through Enterprise Manager,” he said.