Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2004
    Posts
    153

    Unanswered: Oracle Performance

    All,

    I have a One Stored Procedure which I am executing in one schema where it is taking 14 secs and same one is taking 18 minutes time to execute into another schema.

    Could any one let me know what I should look after to find out why the same object is taking these much of different time to execute in two different schema?

    Regards,
    JD

  2. #2
    Join Date
    May 2004
    Location
    BA [ARG]
    Posts
    137
    It depends on many factors... could you post the procedure?
    That could help us for a start.

  3. #3
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    Do you have the same indexes in the second schema? does the second schema have current stats?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  4. #4
    Join Date
    Jan 2004
    Posts
    153
    Thanks for the speedy reply. I can not post the code, because it is more than 1000 lines.

  5. #5
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    enable SQL_TRACE
    run the slow procedure
    run tkprof & see where the 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.

Posting Permissions

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