topic Re: Table SDE_LOGFILE_DATA in Data Management Questions

Table SDE_LOGFILE_DATA

GundarsStarks — Mon, 26 Mar 2012 07:32:47 GMT

Hi!

Table SDE_LOGFILE_DATA has grown very large ~451 776 205 rows. And as it seems it slows down database performance, because of a number of running DELETE FROM [].SDE_logfile_data processes.
Is it possible and safe to clean the SDE_LOGFILE_DATA table(truncate or delete?) ?
Configuration: linux, Oracle10g, ArcSDE 9.2, using Shared log files.

Thanks,

Gundars

Re: Table SDE_LOGFILE_DATA

VinceAngelo — Mon, 26 Mar 2012 09:38:28 GMT

You can often safely TRUNCATE the SDE_LOGFILES/SDE_LOGFILE_DATA pair if
you don't have any active applications dependent on the contents (no sessions
active for the user) *and* you haven't made any permanent logfiles you won't
mind losing in the process. Make sure you TRUCATE or DROP both together.

- V

Re: Table SDE_LOGFILE_DATA

yockee — Mon, 04 Aug 2025 06:56:10 GMT

If I do TRUNCATE on both tables, do I have to stop the map/feature service first ? Which one should be truncated first ? I have similar issues where the table is in production.

If I have so many log tables, should I truncate all of them ?

Re: Table SDE_LOGFILE_DATA

George_Thompson — Mon, 04 Aug 2025 10:48:11 GMT

It looks like those tables / files are used by users on the Enterprise Geodatabase. I am not sure I would truncate those table, unless all connections are not active and closed.