Re: v$object_usage: anyone have bad experience with it?

> The v$sql_plan method doesn't show use index usage for foreign key
> enforcement though.

And when sampling from v$sql_plan, you should do the sampling over different 
workload periods (day, night, month end, payroll cycle etc), otherwise you 
migh miss out some cached statements which are used on specific time periods 
only (due shared pool aging).

Tanel.

--
http://www.freelists.org/webpage/oracle-l

Other related posts: