dbTalk Databases Forums  

Does oracle table locks can effect the socket/thread handling

comp.databases.informix comp.databases.informix


Discuss Does oracle table locks can effect the socket/thread handling in the comp.databases.informix forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
monty
 
Posts: n/a

Default Does oracle table locks can effect the socket/thread handling - 06-20-2007 , 04:56 AM






hi all,

This is very strange kind of problem which i am facing since last few
days. I have got two server running say 1st and 2nd. 1st server sends
request to the 2nd server to execute some component. so 2nd server
take that request, creates a thread in which it call correspoding
component after that does same thing for all the requests. Now 1st
server is firing so many requests one after another.In this process,
Here the complete application is written in the C++. And
everything is working fine. But now i have disabled the oracle table
level lock to increse the performance. now if 1st server is sending 50
request some(one or more;not fixed) requests are not read by 2nd
server. and hence those requests are not processed.
Here i am unable to find out how could a DB level change can
effect the client server communication.

Somebody please help me....it's very critical...

Looking forward to get some responses.

Thanks


Reply With Quote
  #2  
Old   
Clive Eisen
 
Posts: n/a

Default Re: Does oracle table locks can effect the socket/thread handling - 06-20-2007 , 05:14 AM






monty wrote:
Quote:
hi all,

This is very strange kind of problem which i am facing since last few
days. I have got two server running say 1st and 2nd. 1st server sends
request to the 2nd server to execute some component. so 2nd server
take that request, creates a thread in which it call correspoding
component after that does same thing for all the requests. Now 1st
server is firing so many requests one after another.In this process,
Here the complete application is written in the C++. And
everything is working fine. But now i have disabled the oracle table
level lock to increse the performance. now if 1st server is sending 50
request some(one or more;not fixed) requests are not read by 2nd
server. and hence those requests are not processed.
Here i am unable to find out how could a DB level change can
effect the client server communication.

Somebody please help me....it's very critical...

All together now...

Have you tried UPDATE STATISTICS

--
Clive


Reply With Quote
  #3  
Old   
Obnoxio The Clown
 
Posts: n/a

Default Re: Does oracle table locks can effect the socket/thread handling - 06-20-2007 , 06:35 AM




Clive Eisen said:
Quote:
monty wrote:
hi all,

This is very strange kind of problem which i am facing since last few
days. I have got two server running say 1st and 2nd. 1st server sends
request to the 2nd server to execute some component. so 2nd server
take that request, creates a thread in which it call correspoding
component after that does same thing for all the requests. Now 1st
server is firing so many requests one after another.In this process,
Here the complete application is written in the C++. And
everything is working fine. But now i have disabled the oracle table
level lock to increse the performance. now if 1st server is sending 50
request some(one or more;not fixed) requests are not read by 2nd
server. and hence those requests are not processed.
Here i am unable to find out how could a DB level change can
effect the client server communication.

Somebody please help me....it's very critical...


All together now...

Have you tried UPDATE STATISTICS
Bastard! Beat me to it. (

--
Bye now,
Obnoxio

"I'm astonished anyone pays real money for this crap."
-- Cosmo

--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.



Reply With Quote
  #4  
Old   
DA Morgan
 
Posts: n/a

Default Re: Does oracle table locks can effect the socket/thread handling - 06-20-2007 , 08:13 AM



monty wrote:
Quote:
hi all,

This is very strange kind of problem which i am facing since last few
days. I have got two server running say 1st and 2nd. 1st server sends
request to the 2nd server to execute some component. so 2nd server
take that request, creates a thread in which it call correspoding
component after that does same thing for all the requests. Now 1st
server is firing so many requests one after another.In this process,
Here the complete application is written in the C++. And
everything is working fine. But now i have disabled the oracle table
level lock to increse the performance. now if 1st server is sending 50
request some(one or more;not fixed) requests are not read by 2nd
server. and hence those requests are not processed.
Here i am unable to find out how could a DB level change can
effect the client server communication.

Somebody please help me....it's very critical...

Looking forward to get some responses.

Thanks
Your request looks ridiculous in the Oracle group ... why are you
bothering these nice people with it too?

Just what the world needs ... an unknown problem with an unknown version
of an unknown product ... with C++.
--
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.