OraFAQ Forum: Weblogic & Application Server

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Inactive Threads issue (Oracle 11g, OSB DB adapter)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Inactive Threads issue [message #625892]

Wed, 15 October 2014 09:23

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

Report message to a moderator

Re: Inactive Threads issue [message #625893 is a reply to message #625892]

Wed, 15 October 2014 09:28

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Inactive Threads issue [message #625929 is a reply to message #625892]

Thu, 16 October 2014 05:24

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

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?

Report message to a moderator

Re: Inactive Threads issue [message #625939 is a reply to message #625892]

Thu, 16 October 2014 06:58

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

Report message to a moderator

Re: Inactive Threads issue [message #625941 is a reply to message #625939]

Thu, 16 October 2014 07:44

John Watson
Messages: 8964
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.

Report message to a moderator

Re: Inactive Threads issue [message #625960 is a reply to message #625941]

Fri, 17 October 2014 00:39

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 18:12:06 CST 2025