In this demo, Mike Sheffield from Integration Plumbers takes you on a comprehensive tour of the Oracle Enterprise Manager Plugin for PostgreSQL. See how to achieve a single pane of glass view for your database infrastructure, manage high availability clusters, troubleshoot blocking sessions in real-time, and analyze query performance — all without leaving the OEM interface.
Video Chapters
- 00:00 – Introduction & Agenda
- 00:44 – Navigating Targets: Clusters vs. Databases
- 01:25 – Cluster Overview: Replication, Lag & Availability
- 02:50 – How to Perform a Cluster Switchover
- 04:15 – Database Instance Overview & Health
- 06:55 – Agent Architecture (Local vs. Remote)
- 07:54 – Configuration Management & Parameters
- 08:48 – Real-time Diagnostics: Locks & Blocking Sessions
- 10:25 – Viewing Live Database Logs
- 11:32 – Database Metrics: Tables, Indexes & Throughput
- 14:10 – Query Analyzer & Generating Explain Plans
- 17:15 – Setting Metric Thresholds & Alerts
- 18:38 – Incident Manager
- 19:48 – Licensing & Next Steps
