Latest Contributions by yockee

‎08-29-2022

Hi, I have successfully moving one of my feature class into another tablespace. Previously, SDE system tables and user data are in one tablespace. It turns out that Its not just the feature classes that can be moved into another tablespace, but the indexes as well. going further, there are LOB column too. Questions are : 1. When I move the user data (feature class) to another tablespace, do I have to move the indexes and LOB column ? There are, generally, 3 kinds of indexes : Domain, Normal and LOB indexes. NORMAL index is easy to move, but not for the Domain and Lob indexes. I just want to move them all (all indexes, table, and LOB column) 2. What are the associating DBTUNE keyword for that point number 1 ? 3. Is it safe for the integrity of the database to move all the indexes and the LOB column ? Oracle 19c, ArcGIS Pro 2.6, SDE 10.9, Geometry storage : ST_GEOMETRY Thanks. Need your advice.

‎08-28-2022

Hi, I am wondering the reason of separating user data tablespace from SDE system tablespace. I know its better to separate them to avoid SDE tablespace from filling up. But, what if the SDE tablespace has space autoincrement turned on ? How does the separation of tablespace relate to database backup ? Would it be easier to backup and restore when they are separated or otherwise ? Need your advice

‎07-24-2022

@George_Thompson and all, Is it better to separate tablespace for SDE system tables and user tables onto different disk (physically) or the same disk ?

‎07-02-2022

Hi all, It turns out that this works perfectly well, even for oracle too : https://community.esri.com/t5/arcgis-enterprise-documents/update-arcgis-server-services-after-sql-server/ta-p/1181710 Thanks guys

‎06-29-2022

yes George thanks. I might try this. If I change the TNS, It doesn't have any impact right to the integrity of the whole system ? I am just being very very overly cautious.. 🙂 thanks

‎06-29-2022

Yes, I use TNS. You mean I use the same TNS but with different Host and ServiceName (DB) name ? maybe there is equivalent of this procedure on Oracle. thanks

‎06-28-2022

Hi, I need some help. I am in the middle of upgrading ORACLE (from 11g to 19c). The upgrade was success, all FC are still intact and operation is absolutely normal from ArcgisPro 2.8 point of view. But, there is a problem for map services! How do I repoint all the map services to the new data source in the fastest way as possible ? I have like 250 map services and I do not want to do it manually. I know how to do it manually, by opening the MAPX file and repoint all the FCs to their new source. Although its guaranteed success, But...Its just too much with 250 services. Can anyone help with advice or point me to the right direction ? My setup : Geodatabase 10.9.1.2.9, Oracle 19c, ArcGIS Pro 2.8, Geoportal and ArcGIS Server. There are Feature Services, Map Services and image service. Thank you so much.

‎06-27-2022

Hi Vince, You said "I generally create several different tablespaces with different UNIFORM extent..." How do you know which table goes into which tablespace ? How do you decide that this table goes into that tablespace ? I know that I can use SDEDBTUNE keyword to redirect the storage. But isn't it cumbersome if you have a lot of feature classes (I have like couple of thousands FCs) ? Thanks. Need your advice

‎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

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by yockee

Beyond moving user data into another tablesapace

Is it absolutely necessary to separate user data from system tables

Re: Separating SDE system tables from user tables

Re: How to repoint all map services to a new data source ?

Re: How to repoint all map services to a new data source ?

Re: How to repoint all map services to a new data source ?

How to repoint all map services to a new data source ?

Re: CREATE DATABASE USER TOOL and tablespace best pratice

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

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