From: "Arthur" Subject: Trace file is huge Date: 2000/01/28 Message-ID: #1/1 X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 X-Complaints-To: abuse@pacbell.net X-Trace: nnrp2-w.snfc21.pbi.net 949100168 209.233.224.234 (Fri, 28 Jan 2000 14:56:08 PST) Organization: SBC Internet Services X-MSMail-Priority: Normal NNTP-Posting-Date: Fri, 28 Jan 2000 14:56:08 PST Newsgroups: comp.databases.oracle.tools 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 (c) Copyright 1999 Oracle Corporation. All rights reserved. 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?