1 Reply Latest reply on Nov 17, 2010 6:16 PM by alwu-Oracle

    sem_rulebases ('OWLPRIME')

    792262
      Hi,

      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 11.1.0.7.0 - 64bit Production

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

      Regards,
      Kavitha.