Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: turn logging off
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 Sun Apr 22 2001 - 07:46:31 CDT