Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help on simple Oracle question
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