extproc shape lib makes st_functions slow on exadata

58
3
10-01-2019 05:10 AM
Highlighted
New Contributor III

Hi,

We recently migrated arcsde 10.6.1 on oracle 11g to oracle 12c on #exadata. 

Exadata outperforms oracle 11g on normal queries but any queries with st_functions are very slow. We noticed that its due to extproc calls for shape lib.

How could we avoid this or improve?

Tags (3)
Reply
0 Kudos
3 Replies
Highlighted
Esri Frequent Contributor

I would highly recommend that you contact Technical Support to investigate this in more detail. There could be multiple factors involved in this.

Have you performed a trace to compare the times between Oracle 11.2.x.x and Exadata 12c?

Geodatabase

--- George T.
Reply
0 Kudos
Highlighted
New Contributor III

yes. we compared the two databases and performed the trace. the query calls the extproc for each record which decreases the performance.

Reply
0 Kudos
Highlighted
Esri Frequent Contributor

Ok, I would recommend working with support on this.

--- George T.
Reply
0 Kudos