I need advice on this as well. I find that the SDE schema contains 7700+ KEYSET tables. Is this too many ? Is that safe to delete them ? How to delete them safely without having any adverse effect after deletion because they reside in the production ?
My environment : ArcSDE 10.5.0, ArcMap 10.5, Oracle 11G
Solved! Go to Solution.
The KEYSET tables grow so large, around 33000 tables (they never been deleted since the geodb was created). Some questions :
1. What are the processes that trigger it ? One thing for sure is during the join for >100 records. Does JOIN process from web apps trigger this too ?
2. Do I need to reclaim the tablespace after they have been dropped ? But the total amount of their size are 0. Here is the query I use to see their total size :
SELECT segment_name,segment_type, sum(bytes/1024/1024/1024) GB
FROM dba_segments WHERE owner = 'SDE' AND segment_name LIKE 'KEYSET_%'
group by segment_name,segment_type;