Latest Contributions by yockee

‎06-12-2022

Hello, I have KEYSET tables around 30K tables and I am preparing to delete them all. Currently, I used scheduled job that drops some 1000 tables that runs once at midnite. Some curiosities : 1. What cause the formation of these tables ? One cause is that it is needed when joining tables with > 100 records match. 2. Does a process from Map / Feature Service create these tables too ? Say there is a map service that join 2 tables with more than 100 records match. Do this create KEYSET table ? 3. If I drop all of them, will it have any adverse effect on the whole workflow / infrastructure. Will the geodb still be accessible ? Will map services (if it has any effect on map services) still working properly ? I have seen some some readings telling that dropping all Keysets are just fine. I have also follow the instruction on Dropping keyset given by Esri. Many thanks

‎05-30-2022

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

‎05-26-2022

George, is there any documentation about migrating 10.X to 10.9, like for eg this article here? thanks

‎05-25-2022

Hi George. Thank you. anything else i should consider before beginning the work ? what di i have to prepare in advance and what problem should i expect ? thanks again

‎05-25-2022

Hi, I am in the middle of upgrading as well : SDE (from 10.5 to 10.9) and oracle (from 12 to 19) What about objects inside eGDB like Subtype, Domain, relationship class. Will they get copied into FGDB ? And what about indexes, triggers and stored procedure, will they have to be rewritten on to the new DB ? Thanks

‎04-13-2022

Hi, I have a geodatabase that has user data and the sde system tables all mixed up together. The owner of those data are SDE and it is stored in one tablespace. I want to separate the real tables from the system tables so that they are separated. Essentially, I want to create a new entry in SDEDBTUNE so that the new table created by a user will be stored in that tablespace 1. Which parameter in DBTUNE I should change ? I have searched here and there but I just cant find it. 2. Can I add another DBTUNE entry directly using query ? I don't have access to the oracle server via its terminal Iam running Oracle 19c, ArcGIS Pro 2.5, ArcSDE 10.5 thanks for any advice. Please.

‎03-09-2022

Hi @MichaelVolz , Hardly any deletes. Most of the time are inserts and attribute updates. There is a date column that shows when the data were input. The main problem is that these data *have to be shown* in its entirety. I have no idea yet to answer this challenge. Thanks

‎03-07-2022

Hi, What is the best way to present data that are updated quite frequently ? I have 1.8millions rows. Some of them got updated everyday (around 100 - 300 updates daily). Should I use cached map service or not ? If I use cache, do all data got updated, or partially (just the updates only) ? Thanks

‎03-03-2022

Thanks Mike, I have actually read the articles about log. That's why i have confusion in choosing the mode. So I guess, for a mix conditions, choosing the mode is more like trial and error. Anyway, I will try each one of them and see which works best. Thnks

‎02-28-2022

Hi, I can not decide which logfile config I should use, Shared, Session or Pool of log files. I have a database server that is accessed by Desktop user and Web user. They do editing to. The web user edits feature class via Feature Service and web map. They use 1 account for multiple users. Whereas the Desktop user using their own account. So I have a mix. If I read the definition here,i feel i fall between 2 categories : Shared and Session. Currently I am using Shared Log. But, maybe, by changing the log file I can increase the performance. How can I choose the "correct" one ? Based on what decision ? Thanks [ArcGIS Pro, EGDB 10 oracle 12c]

‎02-25-2022

Hi.. i know this has been ages ago. But, i have to comment on this as i just found new info. anyway, in general, there is overhead in having FD. Here what some say : https://esriaustraliatechblog.wordpress.com/2011/10/06/can-you-use-feature-datasets-as-logical-folders-to-store-feature-classes/ and from Geodatabase Tuning and Performance (Gillian Silvertand and Greg Cunningham)

‎02-22-2022

I meant, what is the choice for easy maintenance (backup, tuning, security..etc), put user data into different schema (automatically create new user to own the schema and new tablespace) OR just create user with default tablespace ? Thanks

‎02-22-2022

Hi George, Thanks So, its not necessary to create another schema to separate the user data from system tables ? Creating new user and assign it to default tablespace is sufficient enough. Is it ?

‎02-22-2022

Thanks for your time... I am using Oracle. Maybe same principle can be applied here. thanks

‎02-22-2022

Hi, somehow i got confused.. How do i separate user tables from sde system tables / objects ? Do I : - create a new schema with a user and table space ? or... - create a new user with tablespace ? any suggestions or article that i can read ? Thanks iam using Oracle 12c, ArcGIS Pro 2.8

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by yockee

Dropping KEYSETs tables ORACLE

Re: Delete KEYSET tables

Re: Database Upgrade to 19c or beyond

Re: Database Upgrade to 19c or beyond

Re: Database Upgrade to 19c or beyond

Change tablespace location

Re: Map Service publishing with a lot of new data

Map Service publishing with a lot of new data

Re: Which logfile configuration should be used

Which logfile configuration should be used

Re: Feature Dataset performance

Re: Separating SDE system tables from user tables

Re: Separating SDE system tables from user tables

Re: Separating SDE system tables from user tables

Separating SDE system tables from user tables

Re: Conditional Field List

Editing WFS-T via QGIS

Re: Finding distance between paired points

can not create Feature Class due to connection los...

Re: Feature Dataset performance