Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Spatial and native dynamic compilation
10 views
Skip to first unread message
vsevolod afanassiev
Jun 10, 2013, 8:55:42 PM6/10/13
to
We have 10.2.0.4 database used for Spatial. It runs on AIX LPAR.
Most SQL statements look like this:
SELECT FROM TABLE WHERE SDO_RELATE(B.GEOLOC,
SDO_GEOMETRY(value1, value2, SDO_POINT_TYPE(:XCoord, :YCoord, NULL),NULL,NULL), 'MASK=CONTAINS+COVERS') = 'TRUE'
Plan shows access based on DOMAIN INDEX. We are looking at allocating
more CPU to this LPAR but this will require buying Spatial licenses.
Question: would it help to use native dynamic compilation for
Spatial objects (those owned by MDSYS)? Anyone has real-life experience?
The difficulty is that this is 10.2, not 11, so we will need external C compiler.
Most SQL statements look like this:
SELECT FROM TABLE WHERE SDO_RELATE(B.GEOLOC,
SDO_GEOMETRY(value1, value2, SDO_POINT_TYPE(:XCoord, :YCoord, NULL),NULL,NULL), 'MASK=CONTAINS+COVERS') = 'TRUE'
Plan shows access based on DOMAIN INDEX. We are looking at allocating
more CPU to this LPAR but this will require buying Spatial licenses.
Question: would it help to use native dynamic compilation for
Spatial objects (those owned by MDSYS)? Anyone has real-life experience?
The difficulty is that this is 10.2, not 11, so we will need external C compiler.
0 new messages