
clouddba
295 FOLLOWERS
This blog is for collaborating knowledge on different topic like Oracle DBA,Linux,AWS,Cassandra and other databases.Please subscribe below to get update on my blog.
clouddba
4y ago
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
clouddba
7y ago
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