Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*PLUS terminating slowly
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?
>
>
>> >
> > 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..