AnsweredAssumed Answered

SDE_XML_DOC2 System Table Maintenance

Question asked by jilkahitesh on Nov 29, 2018
Latest reply on Nov 30, 2018 by jilkahitesh

Hello, 

 

RDBMS: Oracle 12c

Parent Enterprise GDB : 10.3.1

Child Enterprise GDB : 10.4.1

 

Few weeks ago I raised a question related to standalone python script of synchronization which takes long time to complete but didnt received any solution on that. In addition to that,  from database trace I found below statement taking more than 10 mins during synchronization process.

 

---------------------------------------------------------------------------------------------------------------------------------------------------------------

UPDATE SDE.sde_xml_doc2 SET xml_doc = :xml_doc, doc_property = :doc_prop ,
xml_doc_val = :xml_doc_val
WHERE
SDE_XML_ID IN ( :xml_id1)

---------------------------------------------------------------------------------------------------------------------------------------------------------------

 

When i saw the records in the "SDE.SDE_XML_DOC2" table, I found from one of column (XML_DOC_VAL) it stores logs for each synchronization process (runs as python script) and during synchronization it appends each day logs due to which the above statement takes longer than expected. It also stores XML_DOC in BLOB segment along with this. 

 

Few starting lines of column (XML_DOC_VAL)  output from table "SDE.SDE_XML_DOC2" 

 

---------------------------------------------------------------------------------------------------------------------------------------------------------------

 ; en ; 20171010 ; 07291500 ; 1.0 ; TRUE ; c:\program files (x86)\arcgis\desktop10.4\ArcToolbox\Toolboxes\Data Management Tools.tbx\SynchronizeChanges ; 20171010 ; 072915 ; SynchronizeChanges "Database Connections\gisdb_ARCDATA.sde" DTPS_KLDTPS_ARCDATA_ALL_FC_EXDATA "Database Connections\kldtps_ARCDATA.sde" BOTH_DIRECTIONS IN_FAVOR_OF_GDB1 BY_OBJECT DO_NOT_RECONCILE ; c:\program files (x86)\arcgis\desktop10.4\ArcToolbox\Toolboxes\Data Management Tools.tbx\SynchronizeChanges ; 

---------------------------------------------------------------------------------------------------------------------------------------------------------------

 

is there any possibility to do housekeeping for this table and other system tables relevant to Synchronize process to improve the performance.

 

Thank you!

Outcomes