Can you post the plan then. Also please post a count of the tables, so that we can guess where most time gets lost.
Here's a doc that describes what you have to do: Autotrace in SQLPLUS
