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

In article <RchG6.5$wN5.11508_at_news.pacbell.net>, devdewboy <devdewboy_at_hotmail.com> writes:
>'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
>
>

You do not need to stop the listener to remove or move the logfile. Instead sign on to the listener and stop logging, remove the file, and start logging again.

use the show command to see the current setting lsnrctl
set password x
show log_status
set log_status off

• Mark D. Powell --
  • Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web ----- http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups NewsOne.Net prohibits users from posting spam. If this or other posts made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net