Select to view content in your preferred language

Can I drop SDE_SESSION_*

629
1
07-27-2011 12:41 PM
DavidRasmussen
Emerging Contributor
Loking through my Oracle database I have come across a few hundred tables in the ARCSERVER schema that are named SDE_SESSION_<SDE_ID> Many of which have LAST_ANALYZED dates of 2008 or earlier.  All of them contain zero rows.  Can I manually drop these tables?
0 Kudos
1 Reply
RashanWalker
Esri Contributor
ArcSDE log file tables in a geodatabase in SQL Server
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//002q0000007t000000

SDE_session<SDE_ID>
The SDE_session<sde_ID> table is created when you are using session-based log files.  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).  The SDE_session<sde_ID> table is dropped when the session disconnects.

Please contact ESRI Support Services to see if this is related to ESRI bug #NIM031995 (fixed in ArcGIS 10 service pack 1).
0 Kudos