Re: Unix Performance Issues

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 29 Jul 1999 18:42:38 +0100
Message-ID: <933270612.6051.0.nnrp-03.9e984b29@news.demon.co.uk>

If you mean:

event = 'nnnnn trace name context forever, level XX'

in the init.ora then some of them will chew up a lot of CPU, some will be barely noticeable in CPU cost, and some will cause trace files to be dumped which may have an impact on performance if the trace directory gets I/O bound.

Care to share with us the events that have been set ? (And the version of Oracle, since some events simply don't work on some versions so events set in the original version of the database may now be doing nothing).

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

>Hello Johnathon,
>
>I've just inherited a db with a large array of event tracking parameters
>within init.ora. Does tracking the event pose any significant
>additional overhead on the server ?
Received on Thu Jul 29 1999 - 12:42:38 CDT