Who Changed My Plan?

Wednesday 10 Jun 2015, 10:00 → 11:00 Europe/London

Linlithgow

It's 5 P.M on a Friday, and you are the lead DBA of a major organisation. Just as you are about to ease out of the door for weekend, the phone rings and there is a panic voice on the other end of the line. It's one of the application administrators for a vital dashboard application, and it seems the query that usually runs in <2s is running for an half an hour. At CERN, databases play a critical role in gathering data from the proton beam collisions and submitting jobs on the Worldwide LHC Computing grid for scientists and physicists to analyze the gathered data. In this session I will cover the techniques available in Oracle 11g and Oracle 12c to control SQL execution plans and application of these techniques in critical scenarios.

document WhoChangedMyPlan_CERN_PrasanthKothuri.pdf