topic Can I drop SDE_SESSION_* in Data Management Questions https://community.esri.com/t5/data-management-questions/can-i-drop-sde-session/m-p/615930#M34777 <HTML><HEAD></HEAD><BODY><SPAN>Loking through my Oracle database I have come across a few hundred tables in the ARCSERVER schema that are named SDE_SESSION_&lt;SDE_ID&gt; Many of which have LAST_ANALYZED dates of 2008 or earlier.&nbsp; All of them contain zero rows.&nbsp; Can I manually drop these tables?</SPAN></BODY></HTML> Wed, 27 Jul 2011 19:41:26 GMT DavidRasmussen 2011-07-27T19:41:26Z Can I drop SDE_SESSION_* https://community.esri.com/t5/data-management-questions/can-i-drop-sde-session/m-p/615930#M34777 <HTML><HEAD></HEAD><BODY><SPAN>Loking through my Oracle database I have come across a few hundred tables in the ARCSERVER schema that are named SDE_SESSION_&lt;SDE_ID&gt; Many of which have LAST_ANALYZED dates of 2008 or earlier.&nbsp; All of them contain zero rows.&nbsp; Can I manually drop these tables?</SPAN></BODY></HTML> Wed, 27 Jul 2011 19:41:26 GMT https://community.esri.com/t5/data-management-questions/can-i-drop-sde-session/m-p/615930#M34777 DavidRasmussen 2011-07-27T19:41:26Z Re: Can I drop SDE_SESSION_* https://community.esri.com/t5/data-management-questions/can-i-drop-sde-session/m-p/615931#M34778 <HTML><HEAD></HEAD><BODY><SPAN>ArcSDE log file tables in a geodatabase in SQL Server</SPAN><BR /><A href="http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002q0000007t000000">http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002q0000007t000000</A><BR /><BR /><SPAN>SDE_session&lt;SDE_ID&gt;</SPAN><BR /><SPAN>The SDE_session&lt;sde_ID&gt; table is created when you are using session-based log files.&nbsp; This table is used to track log file records when a connected session creates a selection set that exceeds the application threshold (100 records in ArcMap).&nbsp; The SDE_session&lt;sde_ID&gt; table is dropped when the session disconnects.</SPAN><BR /><BR /><SPAN>Please contact ESRI Support Services to see if this is related to ESRI bug #NIM031995 (fixed in ArcGIS 10 service pack 1).</SPAN></BODY></HTML> Tue, 18 Dec 2012 22:35:39 GMT https://community.esri.com/t5/data-management-questions/can-i-drop-sde-session/m-p/615931#M34778 RashanWalker 2012-12-18T22:35:39Z