Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help on simple Oracle question

Re: Need help on simple Oracle question

From: Bill <bli01_at_yahoo.com>
Date: Thu, 11 Nov 2004 13:18:42 -0600
Message-ID: <10p7enomdndkva8@corp.supernews.com>


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" <x_at_x.com> wrote in message
news:xEOkd.12243$up1.9668_at_text.news.blueyonder.co.uk...

"Bill" <bli01_at_yahoo.com> wrote in message news:10p7cjkf9d2mqa5_at_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 Received on Thu Nov 11 2004 - 13:18:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US