Latest Contributions by yockee

‎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

‎02-21-2022

@VinceAngelo Hi Vince. Maybe you can give me some advice... Thanks . I read https://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/configuration-parameters-oracle.htm but can't find any info on this. I read that 1 user can have multiple tablespaces, with 1 default. Thanks Iam using arcgis 10.5, Arcgis pro 2.8 and EGDB 10.5 Oracle 11g / 12c

‎02-20-2022

Hi, How can I store Feature Class in certain schema ? Say I create a user 'USR1', and tablespace 'USR1_TBS'. I want a Feature Class "electric_pole" to be stored in USR1_TBS Which specific parameters of SDE DBTUNE that I can set to achieve this ? Thanks

Online Status	Offline
Date Last Visited	‎02-04-2026 05:39 PM

My Ideas

Latest Contributions by yockee

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: How to store Feature Class in certain schema

How to store Feature Class in certain schema

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