Hi there, This some queries I am using to check access predicate efficiency. First two small functions. Access predicate: And filter predicate Usage as follow: Check index access predicates efficiency… Read more »
Hi There, This the query I am using to identify good candidate sql statements for result_cache sqlpatch. You can adjust to some specific schema and when you are fine with… Read more »
Hi there Giving an SQL tuning training session, I came to the following point: This query: Gives this plan: Considering that the solution is: Giving the following execution… Read more »
Hi there, what’s wrong on the picture bellow? When trying to get sql activity behind there is nothing. What is session 6644 doing? Ok, here we have… Read more »
Hi There, I had a chance to play a little bit with the latest Exadata X5-2 and OVM and here is something really cool. I have create two VMs to… Read more »
Hi there, The idea came to me while running an audit to identify bottlenecks in an Oracle infrastructure composed of two servers with many single instances. Due to lack of… Read more »
Hi there, I got an interesting question during a SQL performance and tuning training session from one student. In this simple query select name from A union all select… Read more »