I cannot change the query as the data is required. Are there any init.ora parameters i need to look at?..As i said before, the targetareaid table has 4000 rows and the same table on the dev db has 1000 rows. I increased sort_area_size and hash_area_size for my session to no avail!.

Thanks in advance,
Chucks