Re: process.dat goes larger and larger.

Actually the Performance goes down if ORACLE trace is enabled. Apart from stopping the Trace via the Listener.ora file (EPC_DISABLED=TRUE) , I was told by Oracle Corp to delete the process.dat file from the $ORACLE_HOME/otrace/admin directory . Databases are running fine as ever.

-Thiru

Joe wrote:

> 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 - 11:13:47 CDT