Oracle Slowing Down Each turn - Newbie

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Gene Ariani
    #1

    Oracle Slowing Down Each turn - Newbie

    I am fairly new to Oracle and I would appreciate if some one can point me to
    a right direction.

    I have store procedure that takes about 3 minutes to run. If I run the same
    procedure again suddenly it takes 7 minutes to un and some time up to thirty
    minutes to run. There is no traffic on this server at this time and its a
    test server.

    And then suddenly it takes 3 minutes to run again.


    Any help is appreciated it.


    Gene


    Tags: None
    • Bricklen
      #2
      Re: Oracle Slowing Down Each turn - Newbie

      Gene Ariani wrote:
      I am fairly new to Oracle and I would appreciate if some one can point me to
      a right direction.
      >
      I have store procedure that takes about 3 minutes to run. If I run the same
      procedure again suddenly it takes 7 minutes to un and some time up to thirty
      minutes to run. There is no traffic on this server at this time and its a
      test server.
      >
      And then suddenly it takes 3 minutes to run again.
      >
      >
      Any help is appreciated it.
      >
      >
      Gene
      >
      >
      Post your code, oracle version, os, etc

        Comment

        Previous template Next
        Working...