Expand Oracle EM12c’s native database management capabilities to the popular PostgreSQL database platform
See hundreds of PostgreSQL health, availability, performance, and replication related metrics
Gain real-time diagnosis of PostgreSQL statement, including the longest running, most commonly executed, rows returned, etc.
Extend the monitoring capabilities of Oracle Enterprise Manager Cloud Control 12c (EM12c) to PostgreSQL database environments
Increasingly, organizations are utilizing Oracle EM12c to manage not only the Oracle database workloads – they are also leveraging the monitoring, management, provisioning, and private cloud management capabilities of EM12c to manage critical heterogeneous non-Oracle workloads.
In particular, Oracle EM12c is often used to manage the entire database landscape within the enterprise. The PostgreSQL plug-in specifically expands Oracle EM12c’s native database management capabilities to the popular PostgreSQL database platform.
Oracle Enterprise Manager represents the cutting edge of database management and increasingly customers are adopting the usage of EM12c to manage their entire database estate beyond just Oracle Database to Microsoft SQL, IBM DB2, Sybase ASE, as well as popular open source database workloads.
- Native EM12c thresholds and incidents for common PostgreSQL problems
- Visibility into PostgreSQL high availability via replication monitoring
- Details about the health, size, usage, and activity of tables, indices, triggers, prepared transactions, and sequences
- Displays configuration settings of the PostgreSQL server both now and after the next reboot
The Oracle EM12c plugin for PostgreSQL helps you answer questions about your PostgreSQL database landscape such as:
- At a glance, is the database server up and are each of the database instances available?
- How large are my indices? What is the disk usage ratio of database data vs indices?
- How many of the backends are in use? How many are remaining?
- What is the synchronization state of replication?
- How big is the database?
- How many times in the past hour/week/etc has a particular SQL query been executed?
- What are the most expensive SQL queries the server is processing right now?
- Over the last month, which SQL queries are most commonly being executed?