blue medora oracle enterprise manager (em12c) plug-in for postgresql
TRANSCRIPT
© 2014 Blue Medora LLC All rights reserved
Blue Medora Oracle Enterprise Manager 12c Plugin for PostgreSQL Overview
2 2
PostgreSQL Monitoring in Oracle Enterprise Manager
New plugin for Oracle Enterprise Manager 12c Developed by Blue Medora Extends the best of class database monitoring capabili>es of Oracle EM12c to PostgreSQL
3 3
PostgreSQL Monitoring in Oracle Enterprise Manager
Available as a fully func>onal free edi=on for the Oracle EM12c community
4 4
Enabling EM12c heterogeneous database management
Manage your en>re database landscape in EM12c
5 5
Key Benefits
Status dashboard view with intelligent feedback
6 6
Key Benefits
Advanced diagnos>cs (for tables, indices, and SQL queries)
7 7
Key Benefits
View, compare and search configura>on
Iden>fy expensive SQL queries
8 8
How it works
The plugin is installed and configured adding a new PostgreSQL target type to EM12c
9 9
How it works
The plugin connects to each PostgreSQL instance via a remote, agentless, JDBC connec>on Why this is great § No need to install an agent
on each PostgreSQL server § Monitor mul>ple PostgreSQL
instances from a single OMA
Oracle Enterprise Manager 12c Management Server (OMS)
Oracle Management Agent (OMA)
Blue Medora PostgreSQL Plug-‐in
JDBC Connec>ons
10 10
How it works
Add a target for each PostgreSQL instance All databases are monitored and displayed within the plugin UI
11 11
UI Walkthrough – Instance Overview Page
Quickly iden>fy problems with a PostgreSQL instance Overall instance status and five key status indicators Intelligent plain-‐language status details
12 12
UI Walkthrough – Configura=on Page
Visibility into all PostgreSQL configura>on values Current value as well as reboot value, reset value, range, and type
13 13
UI Walkthrough – Database, Tables, Indices and Queries
Powerful analysis tools provide insight into Table, Index, and Query problems for individual databases View historical or real >me data and drill-‐down to iden>fy the root cause of poor performance
14 14
PostgreSQL SQL query deep dive
View an individual SQL query’s performance
characteris>cs in real >me or historically
Easily navigate to a database on a given instance
15 15
PostgreSQL SQL query drill down
Iden>fy all running SQL queries and their
resource usage
View the user execu>ng the queries
View cumula>ve, average, as well as recent execu>on
>mes
16 16
Dig into PostgreSQL Metrics
• Nearly 200 PostgreSQL metrics available
• Compare performance and configura>on across mul>ple PostgreSQL instances
• Set custom EM12c alerts
• View the metric in real-‐>me or customized historical views
• Create your own custom PostgreSQL reports using BI Publisher or Informa>on Publisher
17 17
Prerequisites
§ Oracle Enterprise Manager 12c R3 (12.1.0.3.0) or greater • No addi>onal Oracle management packs are required
§ PostgreSQL v9.0 or higher • With monitoring enabled (refer to User Guide)
18 18
Resources
§ Blue Medora EM12c Plugin for PostgreSQL DB Product Page • hXp://www.bluemedora.com/product/oracle-‐enterprise-‐manager-‐plugin-‐postgresql-‐database
© 2014 Blue Medora LLC All rights reserved
Backup
20 20
Screenshot – PostgreSQL server overview
21 21
Screenshot – PostgreSQL database details
22 22
Screenshot – PostgreSQL configura=on details
23 23
Screenshot – PostgreSQL tables deep dive
24 24
Screenshot – PostgreSQL indices deep dive
25 25
Screenshot – PostgreSQL SQL queries deep dive
26 26
Screenshot – PostgreSQL thresholds
27 27
Screenshot – PostgreSQL “All Metrics” view
28 28
Screenshot – PostgreSQL topology view