Re: process.dat

From: Roger Jackson <rjackson_at_wire.net.au>
Date: Wed, 7 Jul 1999 19:50:03 +1000
Message-ID: <7lv8h8$ghm$1@caley.wire.net.au>

Greg,

If Oracle trace is turned ON the files process.dat, regid.dat, collect.dat, and facility.dat are written to in $ORACLE_HOME/otrace/admin. These files are put into the SGA and when the files grow too large (about 5M), the SGA can run out of space and possibly cause SQL*Plus and svrmgr sessions to hang.

If you have turned OFF Oracle Trace you can remove these files and run the utilty $ORACLE_HOME/bin/otrccref (which recreates the *.dat files to the default size).

My understanding is that these files will no longer grow until otrace is turned back on.

Regards,

Roger Jackson

Greg Caulton <gcaulton_at_sympatico.ca> wrote in message news:3782DB03.BAD5AE66_at_sympatico.ca...
> if Oracle trace is not running what is the file process.dat in the
> otrace directory used for - is it constantly written to, does in grow in
> size - any information gratefully received.
>
> thanks
>
> Greg
>
Received on Wed Jul 07 1999 - 04:50:03 CDT