Re: Listener and its log file (?size affecting performance?)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 27 Apr 2001 18:46:14 +0200
Message-ID: <bd8jetouv19nofmht5o43ucnr4lo50b3t0@4ax.com>

On Fri, 27 Apr 2001 09:28:11 -0700, "devdewboy" <devdewboy_at_hotmail.com> wrote:

>'morning,
>
>Subject: Listener and its log file
>The question deals with any OS and Oracle 8.x version.
>If the listeners log file is hugh say 50 megs+, does this hamper the
>database in any way? Overhead, slow listener down at startup or during
>normal operation?
>
>My followup to this is if I move the file (cleanup), is it required that I
>shut the listener down first and then move/delete the log, or can I do this
>while the listner is running?
>
>thanks,
>dew
>

Yes it does, but only it the log get really huge (like 50+M). It will slow down connects, as the connect needs to be appended to the log.

You can issue set log_status = off in lsnrctl to disable logging these mssages completely. AFAIK there is no way to set this in listener.ora

You can delete the file on the fly, stopping a listener for a while should not be a problem though, as the listener is a broker only, there are no persistent connections.

Hth,

Sybrand Bakker, Oracle DBA Received on Fri Apr 27 2001 - 11:46:14 CDT