Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2009

    Unanswered: System taking far too long to sort tables.

    Hi everyone, i've been having a problem with my oracle lately, the system seems to be taking far too long to sort tables and i'm clueless as to why is that happening or how to fix the problem........ Can some1 help me

  2. #2
    Join Date
    Aug 2003
    Where the Surf Meets the Turf @Del Mar, CA
    Provided Answers: 1
    You have table & DDL. We don't
    You have data & DML. We don't.
    You have code. We don't.

    You have ALL the information & can't debug the problem.
    Why do you expect others, who have NO details, to solve your mystery?

    enable SQL_TRACE & process trace file to see where time is being spent.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Liverpool, NY USA
    Also, what version of oracle do you have and do you gather statistics on a regular basis.
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts