Re: Login Slow on One Database using ArcGIS

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Thu, 4 Jan 2018 13:51:27 +0100
Message-ID: <CALH8A902zkVdAXbu_v=rL-LSNvyHuts_+od3L9tTCdENZS01vg_at_mail.gmail.com>

Sallie,

maybe it's worth to distinguish if the time is spent before or after a session is initiated.
So I'd suggest to enable SQL*NET tracing on server side. Similar to

TRACE_LEVEL_SERVER=USER
TRACE_FILENO_SERVER=6
TRACE_FILELEN_SERVER=51200
TRACE_UNIQUE_SERVER=ON
TRACE_TIMESTAMP_SERVER=ON
TRACE_DIRECTORY_SERVER=/home/oracle/SERVER_trace

LOG_DIRECTORY_SERVER=/home/oracle/SERVER_trace DIAG_ADR_ENABLED=OFF ADR_BASE = /u01/app/oracle
.

I'm not sure if it was somewhere in the thread already: is the ArcGIS running on the clients PCs or on a dedicated application server? (I'm not an ArcGIS guy, so excuse me if this question sounds rubbish for you).

Martin

-- 
Martin Berger                Oracle ♠
martin.a.berger_at_gmail.com _at_martinberx <https://twitter.com/martinberx>
^∆x      http://berxblog.blogspot.com




2018-01-04 13:34 GMT+01:00 Mladen Gogala <gogala.mladen_at_gmail.com>:



> 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 Consultanthttp://mgogala.freehostia.com

>

>


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

Received on Thu Jan 04 2018 - 13:51:27 CET