Re: [Q] Server Logon Performance

From: Ludo Joris <lujo_at_ruca.ua.ac.be>
Date: 1997/09/08
Message-ID: <3413be69.4933693@news.ruca.ua.ac.be>#1/1

candrews_at_iafrica.com (Clayton J Andrews) wrote:

>Can anyone offer advice or comment on the reasons for abnormally slow
>logons to Oracle 7?

Clayton,

I'm dealing with one possible reason right now. On my platform (HP-UX 10.20) and my release (7.3.2.2) Oracle Trace is enabled by default, although the documentation says it isn't. Every time a user logs in, via a terminal session or via SQL*Net, the files $ORACLE_HOME/otrace/admin/progress.dat and regid.dat grow larger or get updated. The larger these files, the longer your connect times.
If you think this is your problem, please read the following Oracle document:

Title: Oracle trace is enabled by default. ID: 12195827.61 CR-153942
Keywords: TRACE;EPC_DISABLED

HTH

--
Ludo Joris
RUCA - University of Antwerp, Belgium
lujo_at_ruca.ua.ac.be

Received on Mon Sep 08 1997 - 00:00:00 CDT