Re: Login Slow on One Database using ArcGIS
Date: Thu, 4 Jan 2018 13:33:53 +0000
Message-ID: <CY1PR09MB10983C098F97C3BAE7C5353E891F0_at_CY1PR09MB1098.namprd09.prod.outlook.com>
Sallie,
Is the slow geodatabase versioned, perhaps lots of edits with A and D tables? Are you using three-tier connections, or direct connections? Something in the SDE metadata tables, where ArcGIS looks for all of its information at login and other times is what is different between a connection to the database through TNS and ArcMap or ArcCatalog.
Sherrie Kubis
Database Team Lead
Information Technology Bureau
Southwest Florida Water Management District 2379 Broad Street
Brooksville, FL 34604-6899
352.796.7211 x4033
sherrie.kubis_at_swfwmd.state.fl.us<mailto:steve.dicks_at_swfwmd.state.fl.us>
IMPORTANT NOTICE
E-mails made or received in conjunction with the official business of the District are public records. All e-mails sent to and from this address are automatically archived. For more information regarding the State of Florida public records laws, please visit www.myflorida.com.
From: Sallie Cottingham <Sallie.Cottingham_at_cot.tn.gov<mailto:Sallie.Cottingham_at_cot.tn.gov>>
Subject: Login Slow on One Database using ArcGIS
Date: Wed, 3 Jan 2018 17:16:52 +0000
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
Nashville, TN 37243-34001
Sallie.Cottingham_at_cot.tn.gov<mailto:Sallie.Cottingham_at_cot.tn.gov<mailto:Sallie.Cottingham_at_cot.tn.gov%3cmailto: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
Nashville, TN 37243-3400
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jan 04 2018 - 14:33:53 CET