Results 1 to 2 of 2
  1. #1
    MrBottomFeeder Guest

    Answered: Oracle stored procedure performance problem

    I am having a problem with stored procedure performance. I am creating a package that has 42 procedures. The package has a main procedure which calls the other 41. A global temp table is being used to build up the result.

    The call to the second procedure hangs for a long period of time. Each procedure takes approximately 30-40 seconds to execute when run separately.

    Outside of the stored proc/package world the SQL runs even faster. It appears I have some soft of memory limitation for packages/stored procs.

    Any help would be greatly appreciated.

    Thanks,

    Bill Stimeck
    bstimeck@xcurrent.com

  2. Best Answer
    Posted by aviion

    "1) Do u see any waits
    2) Use dbms_profile
    3) can u write the code which calls the second procedure."


  3. #2
    Join Date
    Nov 2001
    Posts
    25
    Provided Answers: 1
    1) Do u see any waits
    2) Use dbms_profile
    3) can u write the code which calls the second procedure.

Posting Permissions

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