Originally posted by manodba
True, but I want some automated tool that collects that information for me. I would run it on a "stable database" for 1 whole batch cycle and save it elsewhere as some baseline.
Aaah, now the real question. To do this - you probably need to backup v$sql_plan. Then compare new plans with old ones based on hash value and address.