Unix Technical Forum

How can a oracle table lock affect socket/thread handling of OS

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 ...


Go Back   Unix Technical Forum > Database Server Software > Oracle Database > Oracle Miscellaneous

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-08-2008, 12:03 PM
monty
 
Posts: n/a
Default How can a oracle table lock affect socket/thread handling of OS

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-08-2008, 12:04 PM
DA Morgan
 
Posts: n/a
Default Re: How can a oracle table lock affect socket/thread handling ofOS

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
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-08-2008, 12:04 PM
monty
 
Posts: n/a
Default Re: How can a oracle table lock affect socket/thread handling of OS

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.



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
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
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:02 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com