test the in line queries with CBO ( i.e analyze underlying tables and remove off that stupid RULE hint )..

Ofcourse on TEST/ACP box first.

Abhay.