RE: stopiing write to listener.log

[peter . lomax]

Shibu, OK so I now understand a little better your need. Of course there is listener OFF (logging_listener=off) As I said this really does defeat the point.   Their are two approaches that spring to mind. Log Rotation or writing to a pipe. Log Rotation: Every x hours stop the listener, rename the file, start the listener You can then do stats on normal connections and save just the error and startups et al ... Writing to a pipe: Would mean that you create a pipe alert_SID.ora and have a process that would read from the pipe everything but normal connections. The disadvantages are  - that you may not be able to do this on your NT box. - you lose all your stats of cnxs Peter   -----Message d'origine----- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 14:15 À : Multiple recipients of list ORACLE-L Objet : Re: stopiing write to listener.log Hi peter   I have thousands of connection in my  db and  listener.log is growing very fastly. I  want  to flush it manaually  every time I want to either stop it or flush it automatically .My db is 8.1.7 on win2k Do u h ave any solution for this ?   regards, shibu ----- Original Message ----- From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Thursday, February 07, 2002 5:28 PM Subject: RE: stopiing write to listener.log Shibu, What do you really want? Log messages written to /u01/app/oracle/product/8.1.7/network/log/listener.log You could redivert this to /dev/null however this defeats the point. You can rename it every day and archive off after 14 days.   User Failing to connect like Microsoft Transaction Server Look on the metalink "Establish a grant to DBA_PENDING_TRANSACTIONS" HTH Peter -----Message d'origine----- De : Shibu [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 7 février 2002 11:38 À : Multiple recipients of list ORACLE-L Objet : stopiing write to listener.log Hi   How Can i stop Oracle from writing to the file listener.log??   regards, shibu