Find the plan being used

by Granville Bonyata on January 15, 2015

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'
order by inst_id;

Previous post:

Next post: