Re: Login Slow on One Database using ArcGIS
- From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 4 Jan 2018 07:34:58 -0500
On 01/03/2018 01:18 PM, Sallie Cottingham 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
You can also install STATSPACK. However, I don't believe that either
STATSPACK or AWR would help you with this issue. Those tools are made to
diagnose possible problems from the performance indicators and not to
fix problems with the particular application. The first thing that I
would do would be to check V$SYSTEM_EVENT to see whether there are any
unusual events there. What interface is ArcGIS using to connect to the
database? JDBC? ODBC? DBD::Oracle? PHP oci8? Some libraries have built
in tracing method, so you may check what does that give you.
Regards
--
Mladen Gogala
Database Consultant
http://mgogala.freehostia.com
Other related posts: