Re: trace files are huge, bigest 2G

A copy of this was sent to "Arthur" <arthur_at_stario.com> (if that email address didn't require changing) On Fri, 28 Jan 2000 14:54:35 -0800, you wrote:

>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
>
>(c) Copyright 1999 Oracle Corporation. All rights reserved.
>
>Trace file: D:\Oracle\Ora81\NETWORK\TRACE\server7f.trc

based on that path, this is Networking tracing, not database.

In your listener.ora (should be in $ORACLE_HOME\network\admin\listener.ora) put:

TRACE_LEVEL_LISTENER = off
LOGGING_LISTENER=OFF and remove any previous entries.

In your sqlnet.ora in that directory (if one exists), add:

TRACE_LEVEL_CLIENT =OFF
TRACE_LEVEL_SERVER =OFF and remove any previous settings. if one does not exist (the sqlnet.ora file) create one and add that.

then you can remove the trace files if you want (stop the listner, remove the trace, start the listener).

>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.
>
>
>

-- 
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation