Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: turn logging off

Re: turn logging off

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 22 Apr 2001 14:46:31 +0200
Message-ID: <te5khb3e27rv38@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 Sun Apr 22 2001 - 07:46:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US