topic trace in Data Management Questions https://community.esri.com/t5/data-management-questions/trace/m-p/163809#M9130 <HTML><HEAD></HEAD><BODY><P>I have generated a oracle sql trace for a session which is using arcsde with oracle spatial (sdo_geometry). I see lot of read/write on the following.</P><P>Please help me to understand about these objects.</P><P></P><P>Table and index</P><P>==============</P><P>S1_IDX$ table</P><P>S1$_IX1 index</P><P></P><P>Lobs</P><P>=======</P><P>table_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; column_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; segment_name</P><P>SDE_XML_&nbsp;&nbsp;&nbsp;&nbsp; DOC2 XML_DOC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYS_LOB0000134349C00003$$</P><P>SDE_XML_&nbsp;&nbsp;&nbsp;&nbsp; DOC2 XML_DOC_VAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYS_LOB0000134349C00004$$</P></BODY></HTML> Fri, 14 Aug 2015 11:52:53 GMT jayasudha 2015-08-14T11:52:53Z trace https://community.esri.com/t5/data-management-questions/trace/m-p/163809#M9130 <HTML><HEAD></HEAD><BODY><P>I have generated a oracle sql trace for a session which is using arcsde with oracle spatial (sdo_geometry). I see lot of read/write on the following.</P><P>Please help me to understand about these objects.</P><P></P><P>Table and index</P><P>==============</P><P>S1_IDX$ table</P><P>S1$_IX1 index</P><P></P><P>Lobs</P><P>=======</P><P>table_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; column_name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; segment_name</P><P>SDE_XML_&nbsp;&nbsp;&nbsp;&nbsp; DOC2 XML_DOC&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYS_LOB0000134349C00003$$</P><P>SDE_XML_&nbsp;&nbsp;&nbsp;&nbsp; DOC2 XML_DOC_VAL&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SYS_LOB0000134349C00004$$</P></BODY></HTML> Fri, 14 Aug 2015 11:52:53 GMT https://community.esri.com/t5/data-management-questions/trace/m-p/163809#M9130 jayasudha 2015-08-14T11:52:53Z