What is slow slow? For all you know their pcs are slow!

Run a profiler tool
pick that query
run stats pack and see/identify the degeneration of the sql query over time
take the query and whack it to run in some similar test/dev environment
try to tune the query and see if you can
..This is no where close to any sequence. Pick up the perf manual from oracle.com and read it too