3 Replies Latest reply on Dec 9, 2010 9:29 PM by alwu-Oracle

    sem_rulebases ('OWLPRIME')


      I have created the OWLPRIME and executing the query with sem_rulebases ('OWLPRIME') Its taking 3 sec to get result.

      The same query is executed in other environment(environment setup, memory allocation is also same) with the same set of data.
      But in new environment the same query with sem_rulebases ('OWLPRIME') is taking 70 sec.

      I am using Oracle Database 11g Enterprise Edition Release - 64bit Production

      Please help me to solve this performance issue with the OWLPRIME.