Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Inactive Threads issue (Oracle 11g, OSB DB adapter)
Inactive Threads issue [message #625892] Wed, 15 October 2014 09:23 Go to next message
simplesanju
Messages: 36
Registered: July 2008
Member
Hi All,

while load testing, our DB adaptor connection max =1 but we are seeing two connection.
Due to this,there is db stuck thread which leads server are going to warning state.

Can any body suggest possible cause to get this issue or any solution regarding this?

Thanks
sanjana


Re: Inactive Threads issue [message #625893 is a reply to message #625892] Wed, 15 October 2014 09:28 Go to previous messageGo to next message
BlackSwan
Messages: 26730
Registered: January 2009
Location: SoCal
Senior Member
Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/


Please post actual SQL run & the results so we can see what you do & how Oracle responds.
Re: Inactive Threads issue [message #625929 is a reply to message #625892] Thu, 16 October 2014 05:24 Go to previous messageGo to next message
Michel Cadot
Messages: 67294
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
while load testing, our DB adaptor connection max =1 but we are seeing two connection.


So something is wrong in your assumptions.
1/ Your Db connector is bugged
2/ Your max is not 1
3/ The connections do not come from the same "session" (whatever "session" can be in your environment).

Note the ONLY things we know is what you tell us.
Do you think you tell us anything that allow us to diagnose?

Re: Inactive Threads issue [message #625939 is a reply to message #625892] Thu, 16 October 2014 06:58 Go to previous messageGo to next message
simplesanju
Messages: 36
Registered: July 2008
Member

Thanks for your response!!

so if one of manage server getting max =2 which leads
server into warn state so how can overcome from this issue?

Thanks
sanjana
Re: Inactive Threads issue [message #625941 is a reply to message #625939] Thu, 16 October 2014 07:44 Go to previous messageGo to next message
John Watson
Messages: 8319
Registered: January 2010
Location: Global Village
Senior Member
Sanjana, what are you trying to do? With what product?
You mention OSB: that usually means "Oracle Secure Backup", but as you posted in the Performance Tuning forum, that does not sound likely.
Re: Inactive Threads issue [message #625960 is a reply to message #625941] Fri, 17 October 2014 00:39 Go to previous message
simplesanju
Messages: 36
Registered: July 2008
Member
Good Morning John.

Thanks for your reply.

OSB means Oracle Service Bus, one of the oracle ESB product which is on top of Weblogic server.

During our application System Performance Test(SPT) . We are noting that for few of managed servers are going to warning state due to max =2.
Can you kindly help us how to over come this issue.


Thanks
sanjana
Previous Topic: How to configure DADS.conf to use urls on web server?
Next Topic: FRM-41217
Goto Forum:
  


Current Time: Sun Aug 09 12:36:51 CDT 2020