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