Latest Contributions by yockee

‎02-21-2022

@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

‎02-20-2022

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

‎02-18-2022

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

‎02-17-2022

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

‎02-17-2022

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

‎02-15-2022

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.

‎02-15-2022

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

‎02-14-2022

Same effect George. I just found out that the Desktop version that support Oracle 12c is 15.1 Here it says "You must install on all 10.5.1 client machines to use Oracle 12.2.01 with ArcGIS". Mine is 15.0 thanks

‎02-11-2022

Yes. I have the Path in the Environment variables set. I have 2 Oracle Clients, for 32 and 64bit. And the order of the path is set that 32bit is listed before the 64bit

‎02-11-2022

Anyway. Thanks George. I think that Desktop 10.5 simply cant connect to geodatabase in oracle 12c. I don't know, may be I am wrong. But, I am able to connect using ArcGIS Pro 2.6 easily.

‎02-11-2022

Hi, I am just wondering the possibility of connecting to ArcSDE 10.5 hosted on Oracle 12c from Arc Catalog 10.5. The geodatabase is using Oracle 12c (ver 12.2.0.1.0). I have tried putting on the Instance Name these string in Arc Catalog : "sde:oracle12c:dbnew", " sde:oracle12g:dbnew". The Oracle Instant Client that I am using is for 12c 32bit. I can connect fine to Oracle 11 and 12 from DBeaver. The TNSPing to all instances are OK too. I am able to connect to ArcSDE 10.5 (on Oracle 11g) from ArcCatalog 10.5 I have Oracle Instant Client 32bit installed. And the TNS Name is correct too (i am using a copy of working TNS Names format) thank you

‎02-08-2022

All right. Seems that its the only possible way. Thank you 🙂

‎02-07-2022

Hi. I am confused about the use of Log File Pool. I have read : https://desktop.arcgis.com/en/arcmap/10.3/manage-data/gdbs-in-oracle/logfiles-oracle.htm. It seems that the environment I am working now is a mix of Shared and Session-based log. I said its a mix because the geodatabase is edited via desktop client and due to lack of adequate licenses, some edits are going through FS accessed by ArcGIS Pro and web apps. 0. How to see the current pool mode ? 1. Which Log File Pool is the best option ? 2. How do you determined that such mode is the best ? is there any metrics / variables to be checked to determine whether the chosen mode is the best option ? Thanks

‎02-03-2022

Hi George, "What Oracle parameters do I have to check to maximize performance (I want to start with the database first) ? I usually do not touch this unless needed" What I want to do is performance tuning, maybe by increasing SGA or PGA, block size etc, as outlined in some Esri articles about geodatabase tuning. I want to investigate some Oracle parameters, what they are, what their values are and how / when their values are considered bad or good. I can't seem to find any study on this (I know, each database is unique, but I guess the parameters are similar somehow) . Thanks.

‎02-03-2022

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

Online Status	Offline
Date Last Visited	2 weeks ago

My Ideas

Latest Contributions by yockee

Re: How to store Feature Class in certain schema

How to store Feature Class in certain schema

EGDBHealth maximum results

Re: Understanding EGDBHealth

Re: Understanding EGDBHealth

Re: Feature Dataset within Feature Dataset

Understanding EGDBHealth

Re: Conect to Oracle 12.2 from ArcCatalog 10.5

Re: Conect to Oracle 12.2 from ArcCatalog 10.5

Re: Conect to Oracle 12.2 from ArcCatalog 10.5

Conect to Oracle 12.2 from ArcCatalog 10.5

Re: Find Associated EGDB FC in map service

Log File Pool Mode in Oracle

Re: Tuning Geodatabase for Oracle 11g

Find Associated EGDB FC in map service

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