trace files are huge, bigest 2G

From: Arthur <arthur_at_stario.com>
Date: 2000/01/28
Message-ID: <O6pk4.649$S32.2601@nnrp2-w.snfc21.pbi.net>#1/1

Please help,
On Oracle 8i creates a lot of trace files in directory witch not in path in init.ora and with different format.
The biggest file 2G and a lot of 0 and small size.

server7f.trc the size 775M. I tested with TKPROF.

TKPROF: Release 8.1.5.0.0 - Production on Thu Jan 27 16:39:17 2000

Trace file: D:\Oracle\Ora81\NETWORK\TRACE\server7f.trc Sort options: default

count    = number of times OCI procedure was executed
cpu      = cpu time in seconds executing
elapsed  = elapsed time in seconds executing
disk     = number of physical reads of buffers from disk
query    = number of buffers gotten for consistent read
current  = number of buffers gotten in current mode (usually for update)
rows     = number of rows processed by the fetch or execute call


****************************************************************************

Trace file: D:\Oracle\Ora81\NETWORK\TRACE\server7f.trc Trace file compatibility: 7.00.12
Sort options: default

       0  session in tracefile.
       0  user  SQL statements in trace file.
       0  internal SQL statements in trace file.
       0  SQL statements in trace file.
       0  unique SQL statements in trace file.

19995294 lines in trace file.

What is wrong with configuration and if I can delete these files online?

Thank you,
Arthur. Received on Fri Jan 28 2000 - 00:00:00 CST