Re: process.dat goes larger and larger.

Oracle version is 7.3.3 running on HP-UX 10.20.

If the file is the ouput of trace facility, what kind of information can I retrieve/get from the file?

Joe

Sybrand Bakker wrote:

> Process.dat is the output of the Oracle Trace facility.
> You can disable it by setting epc_enable = false in init<sid>.ora, or export
> EPC_ENABLE = FALSE in your oracle .profile, if you are running Unix.
> As you don't specify version and platform I can't provide more specific
> directions.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Joe wrote in message <375A791D.D26B79AE_at_netvigator.com>...
> >I've found that the file process.dat in $ORACLE_HOME/otrace/admin
> >got larger and larger and finally caused the filesystem filled up.
> >Then I shutdown the OracleDB but the file is still there.
> >
> >I want to know
> >1) What does the process.dat file use for?
> >2) Why does it grow without bound?
> >3) If I delete it when the database is down and then
> > start DB again, will there be any loss in DB (data and integrity)?
> > (In fact, I cannot shutdown DB when filesystem, which
> > contains $ORACLE_HOME, is full.). Or how can I remove it?
> >
> >Thanks in advance.
> >Joe
> >joetin_at_netvigator.com
> >
Received on Mon Jun 07 1999 - 09:00:52 CDT