Latest Contributions by yockee

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

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

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

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

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

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

Hi, Thanks for your kindness Danny. For your answer about question 1-3, i get your message. Thank you very much. 🙂 For the last one, I need to supply more details. I meant, for all the values in column "Name", are there any corresponding database parameters that I can check ? eg, just in general : say "backups" or "statementsharing" are marked in color. How to see (prove, by running a query to certain oracle parameters / tables ) that "backups" or "statementsharing" are really causing the performance degradation ? After that, how can I fix that parameters / value in Oracle so that the "backups" or "statementsharing" are not considered as Critical ? And one more thing. It is suggested that I should separate between SDE schema and User schema. How do I prove that such separation will increase performance ? Is there any such queries on Oracle that I can run to prove this ? Some clients just want to see the prove with hard evidence or metric value. 🙂 Thanks again for your help Danny. 🙂 best regard ... View more

@DannyKrouk Maybe you can give me an advice... Many Thanks Danny. 🙂 ... View more

Feature Dataset is not meant for organizing data like Folder and Sub-folder behavior. Their primary purpose is for organizing related feature classes into a common dataset for building a topology, a network dataset, a terrain dataset, or a geometric network. Also, having a lot of FD will generate traffic inside your EGDB.   ... View more