Opened 13 years ago
#3709 new defect
Internal oracle query
Reported by: | ondrejl | Owned by: | aboudreault |
---|---|---|---|
Priority: | normal | Milestone: | 5.6.6 release |
Component: | Input - Native Oracle Spatial Support | Version: | unspecified |
Severity: | normal | Keywords: | |
Cc: |
Description
We have a problem with number of queries like this: SELECT nvl(sdo_level,0), nvl(sdo_numtiles,0) ... FROM all_sdo_index_metadata WHERE sdo_index_owner = :owner and sdo_index_name = :iname ORDER BY SDO_INDEX_PRIMARY which consume about 20% CPU capacity.
Is it internal Mapserver query? What we can do to resolve this? We use many layers with oracle connection, e.g. CONNECTIONTYPE oraclespatial DATA "GEOMETRY FROM (SELECT ID_FB, ZAUDIT0, CTVEREC, ZKODFB, GEOMETRY, DECODE(1,1,1,2,3) as VL_OBRYS ,ID_UZ FROM LPIS_RFB_UCINNE) USING UNIQUE ID_FB"
Note:
See TracTickets
for help on using tickets.