Orablogs has a reference to this wonderful article by Jonathan lewis . After reading thru the article it seems that 10g optimizer has some plusses . the minuses will only be known when application faithfully convert to 10g,
Its the old applications that are always the problem new applications can be tailedmade to the new version.
DBAzine.com: the online portal for database issues and solutions