January 2015

Find the plan being used

When researching a slow running query, the first step is looking at the plan being used. Some queries will have multiple plans in the shared pool, so we need a way to figure out which one is being used. Here’s a useful query to SELECT inst_id, address, hash_value, plan_hash_value FROM gv$sqlarea WHERE sql_id = ‘t3y2hc4378gh2’ […]

Read more →