Latest Contributions by yockee

Hi, When about to run egdbhealth tool, i got message : "WARNING: Connecting user (SDE) is the owner of the eGDB, but they do not have the 'SELECT ANY DICTIONARY' server privilege. Many queries will fail to execute; conslut the eGDBHealth documentation for permissions information. You may click the 'Run' button to execute eGDBHealth, but you are encouraged to get the 'SELECT ANY DICTIONARY' privilege." What is the maximum number of records (Names) or Categories yielded after running the egdbhealth.exe without the "SELECT ANY DICTIONARY" privilege ? By having SELECT ANY DICTIONARY privilege granted, will it change the number of rows obtained and/or giving out more technical recommendations ?  I am using SDE user to run it. I get : 1. Context : 70 Names in 17 Categories 2. Expert : 171 Names in 7 Categories Thanks 🙂   BTW : there slight typo in the egdbhealth app. See the warning section.   @DannyKrouk  ... View more

Hi, I am doing EGDBHealth check but I don't really understand some of the results. Couple of questions :  From "Overview Context tab" pic : 1. There are 3 Criticals issues. They have different Queryelapsed times. For items 1 and 2 (AttachSizeSql and SqlSdeBintypeSize..) they have time < 100ms, why are the marked Critical ? Whereas the item #3 is Critical too with time > 100ms. 2. I find that QueryElapsedTime are italicized if they are >100ms. Why ? Is there any specific reason ? From "Expert Context tab" pic : 3. Suppose that I do not want some parameters included in the examination of EGDBHealth. How do I omit those parameters because some of the evaluated parameters are OK ?  4. Are there any specifics database parameters that directly associated with the values here ?  I am using Oracle 12c and SDE 10.5 Thanks in advance ... View more

Hello there,   I have these crazy map services that need to be mapped out to their corresponding feature classes. How to do this easily ? I don't want to open each map services one by one.   Any suggestion ? thanks alot ... View more

Hi, I am wondering if there are queries to check the geodatabase overall performance ? I want to monitor the performance and tune it. I have geodatabase with condition like this : - being accessed by 20 people max (this is the total peak of concurrent users) editing (through ArcGIS Pro) via web feature service published at Portal on premise and some using ArcMap. - There are many viewers (via web app and android). I guess wildly and without prove : <350 viewers via web apps - SDE schema is not separated from USER schema. No multiple tablespaces nor partitions - All desktop users connect using Direct Connect - Arcgis server, Geodatabase and Portal are hosted separately - Lots of KEYSET tables (7000+ tables) and indexes, lots of unnecessary tables too - Lots of Relationship Classes - Accessed by different clients : Desktop editing, Web (Feature Service editing, Web apps queries, Android apps queries) - Others : Set to OLTP database, Using ST_GEOMETRY as spatial datatype, Non-versioning (because it is not necessary)   - Slow when loading big imagery and feature class - There are 500+ map services - Many times, no separation between Publishing and Production geodatabase. One sample : editing geodatabase via FS published through local Portal - Many Feature Datasets (FD). It is said (ESRI UC 2005, Geodatabase Tuning and Performance, p.12) that having FD will generate unnecessary server activities Questions : 1. What Oracle parameters do I have to check to maximize performance (I want to start with the database first) ?   2. Will removing Feature Dataset helps ? By how much performance will be gained in removing FD ? 3. Should I impose more on utilizing Subtype and Domain ? Are there anything else besides these...?  4. Does having many Map Services affect geodatabase performance ? 5. Which once degrades the server performance the least : Editing via ArcMap using Direct Connect or editing via FS, published at on-premise Portal, using ArcGIS Pro ? One thing for sure is to suggest separation between Publication and Production geodatabase   Thanks for your thoughts and considerations. I appreciate them...  environment : ArcGIS Geodatabase 10.5, Oracle 11g, ArcMap 10.5, ArcGIS Pro 2.8 ... View more