Latest Contributions by yockee

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

Hi, I am having problem in querying using ST_GEOM. I have followed the guideline but without result. Here is the error i get when i do query "select sde.ST_AsText(SDE.ST_Geometry('POINT (10 10)', 0)) from dual;" I have also modified extproc.ora by adding this line : SET EXTPROC_DLLS=ANY.  But the result is still the same. Anybody knows what may be the cause ? How to fix this ? Thanks ... View more

Hi, I just want explanation and discussion.  When do we use such configuration like the picture below ? Are they different geodatabases or single geodatabase but split into 2 databases ?   Thanks ... View more

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 ... View more