Re: Oracle Listener parameters

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 2 Dec 1999 23:27:33 +0100
Message-ID: <944173738.5959.0.pluto.d4ee154e@news.demon.nl>

The consultant is correct. There is a new product used in conjunction with OEM, called Oracle Trace.
In 7.3.2 this was enabled by default causing an enormous amount of overhead. This is one of the methods to disable is by default. A different solution would have been including the EPC_DISABLE=TRUE in the oracle unix user .profile file.

Hth,

--
Sybrand Bakker, Oracle DBA
<hylanddp_at_my-deja.com> wrote in message news:826gie$n2e$1_at_nnrp1.deja.com...
> I'm having trouble with a instance on an HP-UX
> server running 7.3.2.2 where performance degrades
> progressively during the day.
>
> Consultant has advised adding this parameter to
> the SID_DESC section of the LISTENER.ORA file:
>
> (SID_DESC =
>
> (GLOBAL_DBNAME = my.global.name)
> (SID_NAME = mysid)
> (ORACLE_HOME = my/oracle/home)
> (PRESPAWN_MAX = 10)
> (ENVS='EPC_DISABLE=TRUE')<<<<------new
>
> I need to know what this new parm is and what it
> means beyond it being an undocumented feature that
> helped in a similar situation. I have not found
> any documentation via Oracle, Revealnet or text
> books. Thanks!
>
> Den
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Dec 02 1999 - 16:27:33 CST