First of all, bookmarking links is invaluable when you write spatial queries. If you are going to be fast (especially with joins), make sure you use SDO_RELATE (it was 100-1000x faster in order to impose linestrings for me [via SDO_GEOM.RELATE oops]).
-, SQL Developer ( 1.x, ), , , , . , .. , MDSYS, SDO_GEOMETRY. → MDSYS, RTREE SPATIAL. SDO_GEOMETRY , .
, , . , , linestrings . , .