1.Does the app runs multiple queries before it acks successful logon to the
user ? If so logon trigger trace 10046 can help us if there are some
queries that run and if there is any slowness due to that.
2. Does it spawn many connections which server is unable to handle it might
be swapping or please check if the huge pages are used[if Linux]. Since you
are already checked on cpu resource.
3.Any warning messages/errors from OS level ?
On Wed, Jan 3, 2018 at 10:18 AM, Sallie Cottingham <
Sallie.Cottingham@xxxxxxxxxx> wrote:
Mark,
Unfortunately AWR and Statspack is not available on the DBs on this
server, so that complicates things too. This is an older DB that was
created by someone else and handed off to me. I do know that automatic
memory management is not in use.
Sallie
*From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@
freelists.org] *On Behalf Of *Powell, Mark
*Sent:* Wednesday, January 3, 2018 12:00 PM
*To:* ORACLE-L <oracle-l@xxxxxxxxxxxxx>
*Subject:* Re: Login Slow on One Database using ArcGIS
Sallie, do you have access to the AWR or Statspack. I would check the
reports for the problem database to see if any specific waits or queries
stand out as potential issues. The reports should also vie you an idea of
the load. This one database could have 3X the connections as the other
three databases combined for all we know so I say first try to make sure
the instance in fact looks fine using traditional measures. If automatic
memory management features of one type or another are in use verifying that
the memory distribution has not ended up badly skewed should also be one of
the checks on your list.
Mark Powell
Database Administration
(313) 592-5148
------------------------------
*From:* oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on
behalf of Sallie Cottingham <Sallie.Cottingham@xxxxxxxxxx>
*Sent:* Wednesday, January 3, 2018 12:16:52 PM
*To:* ORACLE-L
*Subject:* Login Slow on One Database using ArcGIS
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@xxxxxxxxxx <Sallie.Cottingham@xxxxxxxxxx>*
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*
