Just another little help, If you are on UNIX or AIX, you need to shutdown
your listener before you erase the file. The OS will not actually free up
the space unless the Listener is shut down. It only takes a few seconds to
shut it down, erase the file and then start it backup. Users already
connected will not be effected, just those that try to connect while the
listener is down.
--
John Jones
Senior Oracle DBA
Duke University, OIT
john.jones_at_duke.edu
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
news:te5khb3e27rv38_at_beta-news.demon.nl...
> Your file probably doesn't contain any sql logging but *sqlnet* logging.
It
> logs connection attempts and it also has timestamps.
> That said there are 2 things you can do
> - issue the statement set log_status off
> in lsnrctl, once the listener is running. AFAIK it is not possible to
> include this command in listener.ora or sqlnet.ora
> - periodically reset the log file (just throw it away, Oracle will
recreate
> it)
>
> Hth,
> Sybrand Bakker, Oracle DBA
>
> "ed zappulla" <zappullae_at_rcn.com> wrote in message
> news:9bugos$jfu$1_at_bob.news.rcn.net...
> > Does anyone know how to turn sql logging off? oracle 8.1.6. I found a
1.7
> > gig sqlnet.log file on our system.
> >
> >
> >
>
>
Received on Mon Apr 23 2001 - 09:29:06 CDT
