Spatial (MOSC)

MOSC Banner

Oracle 11.2.0.4 RDMBS spatial performance

edited Mar 9, 2016 4:01AM in Spatial (MOSC) 2 commentsAnswered

Hi,

We have a spatial application on a 11gR2 db (version 11.2.0.4 64 bit) and
we experience performance issues. We I look a the db I see two queries which  take care for > 90% of the db activity:

1) SELECT rid , start_1, end_1 , start_2, end_2
FROM MDSYS.SDO_TXN_IDX_INSERTS
where sdo_txn_idx_id = '21F88$' and :bnd_1 <= end_1 and start_1 <= :bnd_2 and :bnd_3 <= end_2 and start_2 <= :bnd_4


and


2) SELECT PRECX, PRECY, PRECZ, DIEPTE, PARA, GEOMETRIE, ID, LOKAAL_ID, INWIN_INSTANTIE_ID, INWIN INTO :PrecX, :PrecY, :PrecZ, :Diepte, :Para, :Geometrie, :ID, :LokaalID, :InwinInstantieID, :Inwin
FROM DGDTW_TOPOPOINTS
WHERE ID =
(SELECT MAX(ID

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center