Re: SQL*PLUS terminating slowly

Kenneth

As part of Oracle*Trace a shadow process will collect diagnostic trace information. This can be disabled by setting EPC_DISABLED to TRUE in the user environment (on Unix).

HTH. Pete

Kenneth C Stahl wrote:

> Hans Georg Reinfeld wrote:
>
> > Hi,
> >
> > I had the same situation. I have done what tmgn proposed (see "Re:
> > database login very slow" by "tmgn" on 23-Aug-99 at 16:18):
> >
> > << Just move $ORACLE_HOME/otrace/admin/process.dat and regid.dat
> > files to a
> > << Backup Location and see the difference. Or you can set
> > EPC_DISABLED=TRUE in
> > << U'r Session statup files.
> > <<
> > << The reason is becos Oracle Tracing is enabled by default in 7.3.3
> > version
> > << and it slows down the Connections.
> >
> > It helps also when exiting SQL*Plus!
> >
> > Hans Georg .
> >
> > ALianto schrieb:
> >
> >> Hi,
> >>
> >> I always following this newsgroup, but I didn't find the solution of
> >> my
> >> problem. The problem is,
> >>
> >> when user, who using the SQL*PLUS, exit from SQL*PLUS at Unix
> >> prompt. He/She
> >> will waiting for 1-2 minutes after that to find his/her prompt.
> >>
> >> What the problem had been occured with the Oracle ?
> >>
> >> We are using Oracle 7.3.3 running under HP UX 9000 model K380.
> >>
> >> Regards,
> >> Alianto
> >> alianto_at_mincom.co.id
> >
>
> Was this problem fixed in 7.3.4? I was once told that I needed to delete
> the process.dat and regid.dat filea and set ORA_TRACE_ENABLE = false.
>
> I have never seen the EPC_DISABLED parameter before. What is its
> function?
>
> Ken
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------
>
> ----------------------------------------------------------------------------------------------

Received on Thu Aug 26 1999 - 11:01:56 CDT