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@x.com> wrote in message
news:xEOkd.12243$up1.9668@text.news.blueyonder.co. uk...

"Bill" <bli01@yahoo.com> 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