Advertisement

Friday, March 31, 2017

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...

Page 1 of 39123»