use explain_plan and tkprof to see where the delay is.