Re: removing sqlnet.ora

From: Mustapha Nuvvercrap <hashman_at_bigpond.net.au>
Date: Thu, 01 Feb 2001 13:43:43 GMT
Message-ID: <jKde6.98843$xW4.752748@news-server.bigpond.net.au>

How much more overhead is need in appending to a 1Gb files as opposed to a 1KB file ?

"Eitan B" <dba_at_taldor.co.il> wrote in message news:959693$4bg$1_at_news.netvision.net.il...
> on 70x/80x
> ---------
> if tracing by sqlnet.log is on
> and there is no limit on the file size
> then :
> if the file is growing mor the Xmb size
> every time you connect
> it writes to a large file(sqlnet.log) wich needs to be opened
> this is a very big overhead operation
> i found ones a 826mb size log file
>
> Eitan Bar
> DBA
> Taldor Group
> 13 Hayetzira St. P.O.Box 10266
> Kiryat-Arye, Petah- Tikva 49002 ISRAEL
> Phone:l +972 - 3 - 9298268
> Mobile:l +972 - 51 - 655234
>
>
> Ed Zappulla <zappullae_at_rcn.com> wrote in message
> news:94ns71$m62$1_at_bob.news.rcn.net...
> > I've been having a real issue with sqlplus and other utilities
connecting
> > very slowly, 1+ min. I happened to delete my sqlnet.ora file and all is
> > well, they load in less than a second. Any idea:s?
> >
> > ...ed
> >
> >
> >
>
>
Received on Thu Feb 01 2001 - 07:43:43 CST