Re: v$object_usage: anyone have bad experience with it?
- From: Tanel Põder <tanel.poder.003@xxxxxxx>
- To: "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 5 Feb 2005 15:55:15 -0000
> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
