We are testing ... upgrade from 9204 to 9208, no last_analyzed problem, we analyze everyday. Yup you read it right, every day. We did ran into some ora-7445 with sub-queries but "_complex_view_merging"=false solved it. Still awaiting to uncover more bugs. Rjamya -- //www.freelists.org/webpage/oracle-l