Show objects in explain plans

Oracle 9 stores explain plans for all executed queries only for limited time – depends on settings. You can check which objects have been use and how many times:


select operation, p.OBJECT_OWNER, object_name, count(*)
from V$sql_Plan p
group by operation, p.OBJECT_OWNER, object_name
order by object_owner, object_name

Leave a Reply

Your email address will not be published. Required fields are marked *