|
POST
|
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
... View more
03-07-2022
09:26 PM
|
0
|
2
|
1097
|
|
POST
|
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
03-03-2022
07:47 PM
|
0
|
0
|
1026
|
|
POST
|
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]
... View more
02-28-2022
08:42 PM
|
0
|
2
|
1076
|
|
POST
|
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
02-25-2022
05:49 AM
|
1
|
0
|
2394
|
|
POST
|
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
02-22-2022
09:27 PM
|
0
|
1
|
2297
|
|
POST
|
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
02-22-2022
08:58 PM
|
0
|
2
|
2299
|
|
POST
|
Thanks for your time... I am using Oracle. Maybe same principle can be applied here. thanks
... View more
02-22-2022
08:55 PM
|
0
|
0
|
2299
|
|
POST
|
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
... View more
02-22-2022
07:41 AM
|
0
|
10
|
2781
|
|
POST
|
@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
02-21-2022
04:43 AM
|
0
|
0
|
794
|
|
POST
|
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
... View more
02-20-2022
11:59 PM
|
0
|
2
|
835
|
|
POST
|
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
02-18-2022
01:02 AM
|
0
|
1
|
1103
|
|
POST
|
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
02-17-2022
11:05 PM
|
0
|
1
|
2329
|
|
POST
|
@DannyKrouk Maybe you can give me an advice... Many Thanks Danny. 🙂
... View more
02-17-2022
07:11 PM
|
0
|
0
|
2336
|
|
POST
|
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
02-15-2022
07:36 PM
|
4
|
0
|
4678
|
|
POST
|
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
02-15-2022
04:33 AM
|
0
|
4
|
2394
|
| Title | Kudos | Posted |
|---|---|---|
| 1 | 11-25-2024 12:33 AM | |
| 1 | 11-21-2025 12:57 AM | |
| 1 | 11-12-2024 08:22 PM | |
| 1 | 10-13-2024 11:55 PM | |
| 1 | 02-25-2022 05:49 AM |
| Online Status |
Offline
|
| Date Last Visited |
2 weeks ago
|