[Info-vax] Oracle Database vs Oracle/Rdb

[Arne Vajhøj]

On 6/27/2019 10:46 PM, Dave Froble wrote:
> On 6/27/2019 10:22 PM, Arne Vajhøj wrote:
>> On 6/27/2019 10:07 PM, Dave Froble wrote:
>>> On 6/27/2019 5:02 PM, Hein RMS van den Heuvel wrote:
>>>> From a performance perspective, RDb on OpenVMS is probably, but not
>>>> certainly, superior to Oracle-Oracle. They'll probably need more
>>>> capacity (Memory, CPU) to run Oracle-Oracle with similar performance.
>>>
>>> While I'm not a user, one thing has occurred to me.
>>>
>>> Back in the day, when everything ran on one CPU, it didn't matter
>>> which process was running, the CPU could do only one at a time.
>>>
>>> Now today, with lots of CPUs (cores), multiple things can occur
>>> simultaneously, and if every user is waiting on the Oracle engine to
>>> service their needs, it probably is harder to scale that up, than to
>>
>> The Oracle database engine is multi-threaded, so it can service
>> multiple requests in parallel.
> 
> I figured that.  But my question was about scaling up, and that is still 
> my question.  Which is easier and better to scale up?

It is different models. Single thread in multiple processes vs single
process with multiple process. The Oracle DB model will result in more
threads (because there will also be application threads), but can do all
locking within single process. I doubt there is a huge difference in
scalability characteristics.

The Oracle DB model (which includes RDB with the SQL service!) is
by far the most common today for bigger databases, because applications
are usually running on different VM's than databases.

Arne