1. We need to make sure that Grafana is installed already. 2. We need following postgresql dashboard to be imported in Grafana. https://grafana.com/dashboards/4164 3. Please download and install influxDB in postgresql server to be added in Grafana monitoring. wget https://dl.influxdata.com/influxdb/releases/influxdb-1.7.4.x86_64.rpm sudo yum localinstall influxdb-1.7.4.x86_64.rpm 4. Please configure and restart influxDB Please change influxdb.conf /etc/influxdb/influxdb.conf We need to enable it # […] The post Postgres Database Monitoring using Grafana Dashboard using template appeared first o ..read more

A.Enabling  SPM manually to stabilize plan for a particular query For this test case I will create a table with skewed data so that for one bind value it will go for one execution plan and for other bind value,it will go for another execution plan.Ideally this should be good to go for different execution […] The post SPM oracle 12c test case appeared first on clouddba ..read more