Re: trace files are huge, bigest 2G

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/01/29
Message-ID: <949145145.4268.0.nnrp-13.9e984b29@news.demon.co.uk>#1/1

The name and location suggests that they are trace files

from SQL*Net.  Have a look at the
    listener.ora
    tnsnames.ora
    sqlnet.ora
        etc. etc. etc. .ora

files for lines like:

    trace_level_client=16
    trace_level_server=admin

Set such levels to 0, or NONE, and
restart the relevant component of
sqlnet - (usually the listener)

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Arthur wrote in message ...


>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

>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 Sat Jan 29 2000 - 00:00:00 CST