Oracle Database - Queries doing Full Table Scan - Last 15 minutes
In this blog, I am writing down a query to find out queries doing Full Table scan in last 15 minutes in Oracle Database. It can be extrapolated to do...
Sunday, March 26, 2017
Oracle Database - Query Slowness on Active DataGuard - High number of Consistent Gets
Recently I faced a peculiar issue of high consistent gets on the Active Data Guard side for a query. The query had the exact same plan on both the sides...
Saturday, March 25, 2017
Oracle Database - RAC/Grid Infrastructure upgrade - Flex Cluster 12.1.0.2 (.x) to 12.2.0.1 - 3 Nodes
In this blog, I am going to discuss about upgrading clusterware from 12.1.0.2.x to the recently released (Feb 2017) 12cr2 clusterware 12.2.0.1. I am having a setup of 3 node...
