mark(at)mark(dot)mielke(dot)cc writes:
> Does Oracle automatically regenerate prepared plans on occasion?
Not due to statistics changes, only if your schema changes.
(caveat: I last used Oracle back at 8i)
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com