Oracle it seemd have released a new note<http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=309475.1>on Database Tuning including CBO. I already solved couple of issues using the amazing information, save a local copy for your use. 8:) Raj ------------------------------ select standard_disclaimer from company_requirements where category = 'MANDATORY'; -- //www.freelists.org/webpage/oracle-l