Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need help on simple Oracle question
Bill wrote:
> 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
Hundreds? It can handle thousands ... tens of thousands.
Assuming you wrote decent code and didn't both installation and configuration parameters and your hardware isn't mediocre.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Thu Nov 11 2004 - 23:12:33 CST