Delete KEYSET tables

[yockee]

Hi,

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

Thanks

[RiccardoKlinger · Accepted solution]

We have similar issues and will work with this template article: 

How To: Remove orphaned keyset tables in Oracle (esri.com)

[yockee]

Hi,

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; 
 

Thanks

@RiccardoKlinger