Re: Login Slow on One Database using ArcGIS

Hi Sallie,

I have worked on ArcGis on Oracle in past. And as per my experience, Arcgis is CPU intensive application. You can see many recursive sqls related to dba_Tab_columns and dba_ind_columns. Actually as per design of Arcgis, for more users/more user load, they need more cpus.

The reason for that (what I understood) is that user connection load increases, so the recursive calls increases and so to maintain better response time, they need more CPUs.

I feel you are also feeling the same issue when you are logging through application of GIS

Hope it helps

Regards,
Harmandeep

On Wed, Jan 3, 2018 at 10:46 PM, Sallie Cottingham < Sallie.Cottingham_at_cot.tn.gov> wrote:

> I have a server that has 4 databases on it and the user is reporting that
> logging in to one specific database is extremely slow when using VPN, but
> that all of the others are fine.
>
> What I have found out (and confirmed with the user) is that logging into
> the DB thru SQL*Plus or TOAD has no issues. The problem occurs when they
> are logging into the DB thru their application which happens to be ArcGIS.
> This is a standalone DB running 11.2.0.4.
>
>
>
> Our Infrastructure Architect is telling me that the server itself is
> almost maxed out on CPU and so he has added RAM to it. (It is a VM
> machine) He is telling me that I am going to need to increase the SGA on
> the DB to solve the problem.
>
>
>
> Before I go there I wanted to check with this group to provide any ideas
> on what I can look for to help pinpoint the problem. My tendency is to
> think that it is a network problem or some problem with the ArcGIS setup
> since the problem only occurs when using the application, not when access
> is thru SQL*Plus or TOAD. Also, the other 3 databases on this server are
> also running ArcGIS with no issues. I’m just not sure where to begin
> looking and would appreciate any help!
>
>
>
>
>
> *Sallie Cottingham*
>
> Database Administrator
>
> Division of Technology Solutions
>
> Comptroller of the Treasury
>
> 425 Fifth Avenue North
> <https://maps.google.com/?q=425+Fifth+Avenue+North%0D+Nashville,+TN+37243&entry=gmail&source=g>
>
> Nashville, TN 37243
> <https://maps.google.com/?q=425+Fifth+Avenue+North%0D+Nashville,+TN+37243&entry=gmail&source=g>
> -34001
>
> *Sallie.Cottingham_at_cot.tn.gov <Sallie.Cottingham_at_cot.tn.gov>*
> 615-401-7962
>
>
>
>
>
> *The Comptroller’s Nashville office is moving to a new location. Our
> office’s telephone numbers, fax** numbers, and e-mail addresses will not
> change. However, effective December 18, 2017, all mail should be sent to
> the following address:*
>
>
>
> *Tennessee Comptroller of the Treasury*
>
> *Technology Solutions*
>
> *Cordell Hull Building*
>
> *425 Fifth Avenue North
> <https://maps.google.com/?q=425+Fifth+Avenue+North%0D+*_Nashville,+TN+37243_*&entry=gmail&source=g>*
>
> *Nashville, TN 37243
> <https://maps.google.com/?q=425+Fifth+Avenue+North%0D+*_Nashville,+TN+37243_*&entry=gmail&source=g>-3400*
>
>
>

--
http://www.freelists.org/webpage/oracle-l