One way to do it is to query V$SQL_PLAN, which contains the execution plan for each cursor in the SQL cache.
Dig Deeper on Oracle database performance problems and tuning
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.