Re: process.dat goes larger and larger.

I did use it only once and that was about a year ago. I remember it should work as a complete replacement of tkprof and more, it will also trace sqlnet.
There is a otrcfmt utility which allows you to report on the collected trace info, but that's all I remember.

Hth anyway,

Sybrand Bakker, Oracle DBA

Joe wrote in message <375BD094.8BBE094_at_netvigator.com>...
>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 Tue Jun 08 1999 - 06:35:24 CDT