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.
Please help me to understand about these objects.
Table and index
==============
S1_IDX$ table
S1$_IX1 index
Lobs
=======
table_name column_name segment_name
SDE_XML_ DOC2 XML_DOC SYS_LOB0000134349C00003$$
SDE_XML_ DOC2 XML_DOC_VAL SYS_LOB0000134349C00004$$