Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!nntp.giganews.com!peer01.cox.net!cox.net!bigfeed.bellsouth.net!bignumber.bellsouth.net!news.bellsouth.net!bignews4.bellsouth.net.POSTED!dc9f2ff1!not-for-mail From: b User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: Need help on simple Oracle question References: <10p7cjkf9d2mqa5@corp.supernews.com> <10p7enomdndkva8@corp.supernews.com> In-Reply-To: <10p7enomdndkva8@corp.supernews.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 50 Message-ID: X-Complaints-To: abuse@bellsouth.net X-Abuse-Info: Please forward a copy of all headers for proper handling X-Trace: npbhgpngjbkmjfegdbdpiflmbcekedmfhojhikkbagflhcbokamnpngimhfbgkjaabdjakefanobecdhehjjmcbkjboigjlkngollmnedgebobphobdopmkbfjahiccpnmemcpbniimdokgbhbfbbgdbemghfool NNTP-Posting-Date: Thu, 11 Nov 2004 17:20:37 EST Organization: BellSouth Internet Service Date: Thu, 11 Nov 2004 17:20:48 -0500 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:114185 comp.databases.oracle.server:229132 Bill, Just use automatic UNDO and ensure that your transactions are not long running. Also, upgrade to 9.2.0.4 at a minimum. Great performance improvements will be realized. Al Bill wrote: > The Oracle version is 9.0.1. > > When you said as long as the machine can cope, do you mean the processor > speed? > > Also, is there any Oracle configuration parameters that should be noted to > accomodate such transaction requirement? > > Thanks > > > "Dave" wrote in message > news:xEOkd.12243$up1.9668@text.news.blueyonder.co.uk... > > "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 > > >