Originally posted by Nikee

Only the TEMP and UNDO tablespaces are Locally managed tablespaces. All other tablespaces are DICTIONARY managed tablespaces.
In that case, I'd look at the query plan.