Documentation on tuning MDSYS.SDO_GEOMETRY field transfer from Oracle Server to Oracle Client
I am searching for tuning guides discussing how to tune transfer of MDSYS.SDO_GEOMETRY data from Oracle Server to Oracle Client. Currently we are experiencing excessive numbers of roundtrips between Oracle Client and Oracle Server when fields of type MDSYS.SDO_GEOMETRY are part of select clause.
This doc on Oracle Spatial, https://docs.oracle.com/en/database/oracle/oracle-database/19/spatl/spatial-concepts.html#GUID-FFA351D4-F647-4254-B21C-1F50C9D9792E refer white papers on this link http://www.oracle.com/technetwork/database/options/spatialandgraph/. However the last link seems to deal with sales related stuff.