Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.wirehub.nl!news2.euro.net!216.196.110.149.MISMATCH!border2.nntp.ams.giganews.com!nntp.giganews.com!news-hub.cableinet.net!blueyonder!pe1.news.blueyonder.co.uk!blueyonder!text.news.blueyonder.co.uk!53ab2750!not-for-mail From: "Dave" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server References: <10p7cjkf9d2mqa5@corp.supernews.com> Subject: Re: Need help on simple Oracle question Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-RFC2646: Format=Flowed; Original Message-ID: Date: Thu, 11 Nov 2004 18:59:41 GMT NNTP-Posting-Host: 82.39.110.72 X-Complaints-To: abuse@blueyonder.co.uk X-Trace: text.news.blueyonder.co.uk 1100199581 82.39.110.72 (Thu, 11 Nov 2004 18:59:41 GMT) NNTP-Posting-Date: Thu, 11 Nov 2004 18:59:41 GMT Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:114177 comp.databases.oracle.server:229124 "Bill" wrote in message news:10p7cjkf9d2mqa5@corp.supernews.com... > Hi all, > > I have a program which contains a select of a table. And, a 2nd program > which contains an insert to the same table. > > The 2 programs are being executed concurrently hundreds of times per > minute. > Will Oracle be able to handle this without any problem, e.g. locking > problem? Is there anything special I should do to this table, so to > prevent problems? > > Thanks > > as long as the machine can cope with the number of transactions then yes, oracle will because reads do not block writes and vice versa p.s. always mention version