This content has been marked as final.
Show 6 replies
-
1. Re: Performance issues with sem_apis.create_entailment
alwu-Oracle Apr 21, 2012 4:51 PM (in response to 366556)Hi,
Did you run gather stats before all the call? What kind of hardware (CPUs, MEM, I/O) are you using?
On a quad core system, I normally use an option like:
DOP=4,RAW8=T,HASH_PART=32
Now, in your ontology, do you have lots of someValuesFrom?
Thanks,
Zhe -
2. Re: Performance issues with sem_apis.create_entailment
366556 Apr 23, 2012 8:47 PM (in response to alwu-Oracle)Hi Zhe,
I gather statistics after I create the entailment:
execute sem_apis.analyze_entailment('M1_RI');
The machine has Ubuntu OS, 8 CPUs, 16G MEM, and 7500 rpm ATA IO.
I have 5 ontologies in the entailment and about 3500 statements containing someValuesFrom.
Thanks,
A.
just fyi
when I tried EXECUTE sem_apis.create_entailment('M1_RI', sem_models('M1s'), sem_rulebases('OWLPRIME'),sem_apis.REACH_CLOSURE, 'CHAIN' ,'INC=T DOP=4'); it took about 10 or more min but it completed. (I have some chaining in the ontology). -
3. Re: Performance issues with sem_apis.create_entailment
alwu-Oracle Apr 23, 2012 9:48 PM (in response to 366556)Hi,
How many ATA disks do you have? If you are using multiple physical disks, are you using RAID, or ASM, or maybe both?
Can you please start from dropping the entailment and list the performance for each step as follows?
- exec sem_apis.drop_entailment ('M1_RI')
- sem_apis.create_entailment('M1_RI', sem_models('M1s'), sem_rulebases('OWLPRIME'),sem_apis.REACH_CLOSURE, 'CHAIN' ,'INC=T,DOP=4');
- add some new assertions
- re-run sem_apis.create_entailment('M1_RI', sem_models('M1s'), sem_rulebases('OWLPRIME'),sem_apis.REACH_CLOSURE, 'CHAIN' ,'INC=T,DOP=4');
-- add some more assertions
- - re-run sem_apis.create_entailment('M1_RI', sem_models('M1s'), sem_rulebases('OWLPRIME'),sem_apis.REACH_CLOSURE, 'CHAIN' ,'INC=T,DOP=4');
Thanks,
Zhe
Edited by: alwu on Apr 23, 2012 2:48 PM -
4. Re: Performance issues with sem_apis.create_entailment
366556 Apr 23, 2012 11:33 PM (in response to alwu-Oracle)Hi,
I wanted to clarify that I don't see a problem with 'chain' only with the 'SVFH' parameter.
The Oracle installation is just on one disk-space not using RAID or ASM, just a very plain installation.
I'v deleted the entailment. I had to kill the process after running for 2 hours. So I'm not able to get a valid and/or complete entailment running this process:
sem_apis.create_entailment('M1_RI', sem_models('M1s'), sem_rulebases('OWLPRIME'),sem_apis.REACH_CLOSURE, 'SVFH' ,'INC=T,DOP=4'); -
5. Re: Performance issues with sem_apis.create_entailment
alwu-Oracle Apr 23, 2012 11:50 PM (in response to 366556)Thanks. I see.
Can you share with us the ontology? I need to reproduce it locally.
Zhe
alan dot wu at oracle dot com -
6. Re: Performance issues with sem_apis.create_entailment
366556 Apr 27, 2012 9:07 PM (in response to alwu-Oracle)Thank you Zhe. I was able to create entailment running this execute:
EXECUTE sem_apis.create_entailment('test1_RI', sem_models('test1'), sem_rulebases('OWLPRIME'),sem_apis.REACH_CLOSURE, 'SNOMED,INTERSECTSCOH,INTERSECT','INC=T DOP=8 RAW8=T HASH_PART=32');
Edited by: a1239090 on Apr 27, 2012 2:07 PM