Re: Login Slow on One Database using ArcGIS

If ArcGIS is "chatty" and runs a lot of recursive SQL, then could it just be the latency in your network causing the issues? Have you traced the 2 sessions to compare them and see what the deltas are?

On Thu, Jan 4, 2018 at 6:14 AM, Harmandeep Singh <singh.bedi_at_gmail.com> wrote:

> 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 <(615)%20401-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*
>>
>>
>>
>
>

-- 
Thomas Roach
813-404-6066
troach_at_gmail.com

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