Quote Originally Posted by philthee View Post
yeah, statistics have been gathered.
... Etc...
The 10g plan is full of full table scans on the biggest table.
Seems you are missing indexes and/or statistics (on indexes also)....
Check if the indexes on 9i are the same as on 10g in number and columns indexed.