Re: SQL*PLUS terminating slowly

From: Thiru <tmgn_at_excite.com>
Date: Thu, 26 Aug 1999 18:13:24 -0400
Message-ID: <37C5BC04.5CF27DC3@excite.com>

Kenneth,
Try this in U'r Server Listener.ora

SID_LIST_LISTENER=

             (SID_LIST=
              (SID_DESC=
                (SID_NAME=<blah>)
                (ORACLE_HOME= <blah blah>)
               (ENVS='EPC_DISABLED=TRUE')
              )
            )

or
If you are not interested in looking at Tracing information, why dont you simply Delete the Trace files process.dat and regid.dat
or
recreate them using 'otrccref' utility which will set the Trace files to their default Sizes..

-Thiru

Kenneth C Stahl wrote:

> This keeps getting more complicated. I can see how I can set a shell variable in every account on
> UNIX that is accessing Oracle, but I'm working with a system that has only a few host-based
> applications and about 40-50 users who are accessing the database using client applications on an NT
> workstation. Where would I specify EPC_DISABLED setting on the NT workstation? If it were run from a
> dos window I could set the parameter in a shortcut, but for a windows application I'd almost have to
> put it in into the registry, but in that case where?

>

> Ken

>

> tmgn wrote:

>


> > Hi Kenneth,


> > EPC_DISABLED=True  setting in either Client's Shell Variable or in Listener.ora will prevent


> > Client Sessions from writing the Trace Information into process.dat or regid.dat file..


> >


> > I have simply deleted these files in a couple of Databases and everything is running fine..

> >
> > -Thiru
Received on Thu Aug 26 1999 - 17:13:24 CDT