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"

Change History (0)

Note: See TracTickets for help on using tickets.