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: Anyone ever need more file handles on Solaris 8/Oracle 8.1.7

Re: Anyone ever need more file handles on Solaris 8/Oracle 8.1.7

From: Chucky <chuck.carson_at_syrrx.com>
Date: Tue, 17 Dec 2002 07:35:15 -0800
Message-ID: <3DFF4433.2050308@syrrx.com>

Here is what netstat -i showed:

Name Mtu Net/Dest Address Ipkts Ierrs Opkts Oerrs Collis Queue
lo0 8232 loopback localhost 22528 0 22528 0 0   0

ge0   1500 web-0202.syrrx.com web-0202       38486557 8     54064267 0 
    0      0


Is 8 errors bad for ge0?

As far as netstat -s, there were no errors for any of the fields.

????

-Chuck

Chuck Swiger wrote:
> In comp.sys.sun.admin Chuckster <chuckycarson_at_networkcloud.com> wrote:
>

>>Yea, all this has been done. This has been a working system for over a 
>>year. Just recently these intermittent problems appeared, thus it works 
>>one minute and not the next. In the absence of configuration changes to 
>>the oracle client, this rules out syntax errors and etc...

>
>
> Fair enough, however, the obvious can sometimes be overlooked.
>
> Have you enabled tracing for the TNS Listener? Is it getting but failing to
> look up a valid service name, or it is getting the query at all-- perhaps
> you're dropping a few packets, and getting an occasional timeout because the
> machine is busy dealing with other network traffic?
>
> A mildly flaky ethernet cable, or one loose in the RJ45 which only drops one
> packet out of a thousand tends to do fine under testing, but will cause this
> kind of thing under heavier loads. What does netstat -s and -i look like?
>
> Is your app holding a few persistant DB connections open, or are there
> situations where you might create and drop a bunch of connections in a row?
>
> -Chuck
>
> Chuck Swiger | chuck_at_codefab.com | All your packets are belong to us.
> -------------+-------------------+-----------------------------------
> "The human race's favorite method for being in control of the facts
> is to ignore them." -Celia Green

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Dec 17 2002 - 09:35:15 CST

Original text of this message

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