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 -----
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
