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’ […]