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 220.127.116.11.0 - 64bit Production
Please help me to solve this performance issue with the OWLPRIME.