Re: A very interesting problem - frustrating for me but a challenge for you? 9i / mod_plsql .....

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Thu, 10 Mar 2005 09:15:31 -0500
Message-ID: <4M2dnb2fko4Zy63fRVn-tw@comcast.com>

"Shanmuhanathan T" <shanmuha_at_mailinator.com> wrote in message news:vyYXd.25$VL5.138_at_news.oracle.com...

> Mark C. Stock said,on 3/10/2005 6:19 PM:

>> "Oxnard" <shankeypNO_SPAM_at_comcast.net> wrote in message
>> news:K8OdnQI6Cuogo63fRVn-vg_at_comcast.com...
>>
>>>"Noons" <wizofoz2k_at_yahoo.com.au> wrote in message
>>>news:42303a04$0$22850$5a62ac22_at_per-qv1-newsreader-01.iinet.net.au...
>>>
>>>>Jeremy apparently said,on my timestamp of 10/03/2005 10:20 PM:
>>>>
>>>>>So.... what do you think?
>>>>
>>>>Weird locking combination?
>>>>
>>>>--
>>>>Cheers
>>>>Nuno Souto
>>>>in sunny Sydney, Australia
>>>>wizofoz2k_at_yahoo.com.au.nospam
>>>
>>>How could one prove if this is the case? I have a simular situation. Once
>>>every couple of months for no appeant situation the proformance gets very
>>>bad on a application. I have sometimes thought it may be something to do
>>>with the statistics getting weird, however I do not know how to prove
>>>this.
>>>
>>
>>
>> what does the listener log look like at these peek times?
>>
>> could this be an app server related issue?
>>
>> ++ mcs

> No its not an appserver issue because, the sql session
> is inited as soon as the request arrives and the sql session
> only takes the max time to complete.
> -- 
> Shanmu.

what about other app server managed sessions -- is it putting an additional load on the database as it manages its sessions (shot in the semi-dark) ++ mcs Received on Thu Mar 10 2005 - 08:15:31 CST