topic Re: extproc shape lib makes st_functions slow on exadata in Data Management Questions https://community.esri.com/t5/data-management-questions/extproc-shape-lib-makes-st-functions-slow-on/m-p/648912#M36745 <HTML><HEAD></HEAD><BODY><P>Ok, I would recommend working with support on this.</P></BODY></HTML> Tue, 01 Oct 2019 12:41:21 GMT George_Thompson 2019-10-01T12:41:21Z extproc shape lib makes st_functions slow on exadata https://community.esri.com/t5/data-management-questions/extproc-shape-lib-makes-st-functions-slow-on/m-p/648909#M36742 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>We recently migrated arcsde 10.6.1 on oracle 11g to oracle 12c on #exadata.&nbsp;</P><P>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.</P><P></P><P>How could we avoid this or improve?</P></BODY></HTML> Tue, 01 Oct 2019 12:10:37 GMT https://community.esri.com/t5/data-management-questions/extproc-shape-lib-makes-st-functions-slow-on/m-p/648909#M36742 venaktesa_kumarNatarajan 2019-10-01T12:10:37Z Re: extproc shape lib makes st_functions slow on exadata https://community.esri.com/t5/data-management-questions/extproc-shape-lib-makes-st-functions-slow-on/m-p/648910#M36743 <HTML><HEAD></HEAD><BODY><P>I would highly recommend that you contact Technical Support to investigate this in more detail. There could be multiple factors involved in this.</P><P></P><P>Have you performed a trace to compare the times between Oracle 11.2.x.x and Exadata 12c?</P><P></P><P><A href="https://community.esri.com/group/1680">Geodatabase</A>‌</P></BODY></HTML> Tue, 01 Oct 2019 12:19:01 GMT https://community.esri.com/t5/data-management-questions/extproc-shape-lib-makes-st-functions-slow-on/m-p/648910#M36743 George_Thompson 2019-10-01T12:19:01Z Re: extproc shape lib makes st_functions slow on exadata https://community.esri.com/t5/data-management-questions/extproc-shape-lib-makes-st-functions-slow-on/m-p/648911#M36744 <HTML><HEAD></HEAD><BODY><P>yes. we compared the two databases and&nbsp;performed the trace. the query calls the extproc for each record which decreases the performance.</P></BODY></HTML> Tue, 01 Oct 2019 12:39:31 GMT https://community.esri.com/t5/data-management-questions/extproc-shape-lib-makes-st-functions-slow-on/m-p/648911#M36744 venaktesa_kumarNatarajan 2019-10-01T12:39:31Z Re: extproc shape lib makes st_functions slow on exadata https://community.esri.com/t5/data-management-questions/extproc-shape-lib-makes-st-functions-slow-on/m-p/648912#M36745 <HTML><HEAD></HEAD><BODY><P>Ok, I would recommend working with support on this.</P></BODY></HTML> Tue, 01 Oct 2019 12:41:21 GMT https://community.esri.com/t5/data-management-questions/extproc-shape-lib-makes-st-functions-slow-on/m-p/648912#M36745 George_Thompson 2019-10-01T12:41:21Z