This is a discussion on How can a oracle table lock affect socket/thread handling of OS within the Oracle Miscellaneous forums, part of the Oracle Database category; --> Hi All This is very strange kind of problem which i am facing since last few days. I have ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |
| |||
| 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... > > > Looking forward to get some responses. > > > Thanks And this unknown/unnamed component of a system running on an unknown operating system using an unnamed DB of an unnamed version is doing what? If you are going to ask others to help you ... try to meet them half way. And why is it you are locking an Oracle table again? -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org |
| ||||
| first of all my apologies for not explanning the problem properly. As I mentioned earlier also that the complete application is written in the C++ and the components which are called are interacting to the oracle tables to update the tables. Application is for AIX 5.3 OS and the oracle version is 10g. and also i m not locking the table but i m disabling the locks by giving command: ALTER TABLE <table_name> DISABLE LOCK I am doing this to increase the degree of parallasim. let me know if you require any other information. Anyways thanks for your respons. |