Re: sql*plus connect times

Your problem could be due to Oracle Trace. Oracle Trace was introduced in Oracle7 release: 7.3.2.1
It is enabled by default (when installed) in 7.3.2 onwards. To disable this function, there are several things you can do :-

1. Set EPC_DISABLED=TRUE for SQL*Net connections by modifying the 'SID_LIST_listener' clause in the listener.ora' file and add: (ENVS='EPC_DISABLED=TRUE') to the SID_DESC for each 7.3 database. Add the entry AFTER the (ORACLE_HOME=...) clause.

          Eg:             SID_LIST_LISTENER=
                                    (SID_LIST=
                                    (SID_DESC=(SID_NAME=DB1)

(ORACLE_HOME=/oracle/OFA_base/app/oracle/product/7.3.2)
                                    (ENVS='EPC_DISABLED=TRUE')  ) )

Restart the listener.

2) To disable Oracle Trace for a particular session set the environment variable EPC_DISABLED to TRUE.

     Eg: In a Bourne script: EPC_DISABLED=TRUE; export EPC_DISABLED

3) If you do not want any trace file output, (i.e No tracing at all) then shutdown all database and listeners. Remocve the files :- $ORACLE_HOME/otrace/admin/*.dat then restart the listeners and database.

HTH NeilC

Charles Hansis wrote in message
<7shaif$q6d$1_at_birch.prod.itd.earthlink.net>...
>I have a 7.3.2 database with 6 instances on it. (HP9000-T520 4 Proc and 2
g
>RAM) and we are experiencing a extreme delay while trying to connect to
>sql*plus during the "high activity time" in the mornings. We have tried
>using mts and didn't find it making any improvements in performance, also
>added parms in listener.ora to prespawn processes with no noticeable
>results, so I come to the well of knowledge seeking advice on how improve
my
>situation.
>
>Thanks,
>
>Jim H.
>
>
>
Received on Mon Sep 27 1999 - 03:09:34 CDT