Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Need help on simple Oracle question
Bill,
Just use automatic UNDO and ensure that your transactions are not long running. Also, upgrade to 9.2.0.4 at a minimum. Great performance improvements will be realized.
Al
Bill wrote:
> 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 >> >>