Quite often, as Database Administrators we are faced the case, when our attitude to SQLs, our knowledge of topic, is in contraty to what Developers know..
It all comes from fact, that Developers, do not have some information, and look at application from functional point of view…
In this series of posts, I will try to build a bridge between DBAs and DEVs…
So, let’s go to the point..
Subjects that this series will raise:
- Selectivity / Cardinality and Histograms
- How to read execution plans (Explain Plan – sometimes lies ?)
- What is Shared pool – why Devs should know it ?
- Bind variables vs Literals
- Variable Bind Peeking
- Adaptive Cursor Sharing – selectivity cubes
- Access Paths and Join Methods
- Result Set Cache
- Adaptive Optimizations in 12c