Xref: alice comp.databases.oracle.server:56321
Path: alice!news-feed.fnsi.net!netnews.com!newsswitch.lcs.mit.edu!newsfeed.mathworks.com!intgwlon.nntp.telstra.net!vic.nntp.telstra.net!news.mira.net.au!news.mel.ausbone.net!203.36.3.25.MISMATCH!caley!not-for-mail
From: "Roger Jackson" <rjackson@wire.net.au>
Newsgroups: comp.databases.oracle.server
Subject: Re: process.dat
Date: Wed, 7 Jul 1999 19:50:03 +1000
Organization: World Wire Pty. Ltd.
Lines: 32
Message-ID: <7lv8h8$ghm$1@caley.wire.net.au>
References: <3782DB03.BAD5AE66@sympatico.ca>
X-Trace: caley.wire.net.au 931341672 16950 203.36.3.66 (7 Jul 1999 10:01:12 GMT)
X-Complaints-To: usenet@caley.wire.net.au
NNTP-Posting-Date: 7 Jul 1999 10:01:12 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2014.211
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211

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@sympatico.ca> wrote in message
news:3782DB03.BAD5AE66@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
>