Why is my SPARQL query so slow when I use property restrictions?

What is the hardware configuration? Please list the SGA, PGA, and your I/O subsystem. Are you using a VM?

Assume the hardware used is a balanced one, we can try the following and see if we can finish a reduced query in the designated time constraint.

e.g.

Run this first:

prefix ...

select  ... {

  ?annulus a owl:Class ; rdfs:label ?annulusLabel ;

}

limit 100

Run this the second,

select ?annulus ?annulusLabel ?od ?wt {

  ?annulus a owl:Class ; rdfs:label ?annulusLabel ;

    rdfs:subClassOf/rdfs:subClassOf rdl:X101001915

}

limit 100

Run this the third,

select ... {

  ?annulus a owl:Class ; rdfs:label ?annulusLabel ;

    rdfs:subClassOf/rdfs:subClassOf rdl:X101001915 ;

    rdfs:subClassOf [ a owl:Restriction ; owl:onProperty rdl:X101001912 ;

      owl:hasValue ?od ] ;

}

Please record the SQL Monitor report and please also take a snapshot before and after running the query, and generate an AWR report. It is very useful to see the top waits. All these will be very helpful for Oracle to understand what is going on.

Thanks,

Zhe Wu