Re: Need help on simple Oracle question

From: b <b_at_aol.com>
Date: Thu, 11 Nov 2004 17:20:48 -0500
Message-ID: <VARkd.6214$jE2.4223@bignews4.bellsouth.net>

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
>>
>>

>
>
> 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 - 16:20:48 CST