Delete KEYSET tables

238
2
Jump to solution
01-11-2022 11:25 PM
yockee
by
Occasional Contributor

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

0 Kudos
1 Solution

Accepted Solutions
RiccardoKlinger
New Contributor III

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

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

View solution in original post

2 Replies
RiccardoKlinger
New Contributor III

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

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

yockee
by
Occasional Contributor

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 

0 Kudos