Re: Oracle and LiveWire db service

On 19 Mar 1999 16:06:37 GMT, "jacob" <bogers_at_kpn-telecom.nl> wrote:

>looks like a deadlock to me.
>
>Are multiple sessions accessing a table exclusivly (for writing or
>updating)?
>

No, they are accessing multiple tables for reading ONLY.

>bbeausej_at_my-dejanews.com schreef in artikel
><7croeh$7r9$1_at_nnrp1.dejanews.com>...
>>
>>
>>
>> Hi everyone,
>>
>> We are using Netscape Enterprise server 3.6 on a Sun Ultra-2 (2x300mhz,
>2gig
>> ram) with Solaris 2.6.
>>
>> We are having problems with the livewire environnement. We use an Oracle
>7.3.2
>> db server and a Oracle 7.3.4 client.
>>
>> The problem we get is that after sometime (less than 15 to 20 minutes)
>the NES
>> process takes up all the cpu of the machine. (98% cpu) We investigated
>almost
>> all avenues those avenues to solve the problem:
>>
>> We tried to increase the segment length on the database but it did no
>good.
>>
>> From the logs our code generates, the DbPool from our applications get
>> disconnected after a certain time like if they were saturated. Each app
>uses
>> (in the appmgr) 8 connections. We did try to increase this number but
>again,
>> it didn't help. The oracle server machine is running fine, no cpu
>overload,
>> no io overload nothing.
>>
>> The output from the truss command on the NES gives us lwa_sema_wait
>errors.
>> (#ERRSTART)
>>
>> Any ideas anybody?
>>
>> Benoit Beausejour (bbeausej_at_videotron.net, CyBeReReAL_at_IRC))
>> Java Developer -- Le Groupe Videotron Ltee
>> http://www.infinit.net & http://www.videotron.net
>>
>> -----------== Posted via Deja News, The Discussion Network ==----------
>> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>
>>
Received on Sun Mar 21 1999 - 13:00:22 CST