Re: Login Slow on One Database using ArcGIS

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


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