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