Re: Have you extra approach identifying oracle standalone ASM architecture？

On 8/16/23 03:45, Douglas Dunyan wrote:
> A RAC instance with a CRS installation should have an entry for
> '+ASM[1...99]' (assuming you don't have any 100 node or larger
> clusters) and are indeed using ASM for your shared storage requirement.
>
Don't even joke about 100 node RAC. Somebody will build it and then, in most likelihood, a member of this list will be asked to optimize it and get rid of all those pesky gc* events in the AWR report. Mogens Norgaard, a notable Oracle expert who was with Oracle Denmark for a long time, wrote a paper titled "You Probably Don't Need RAC", which I advise you to find and read.

You see, there is something called 'the law of diminishing returns". I really believe that adding nodes after the 4th or the 5th node makes no sense from the performance point of view. The original idea was one of the Lego systems: use cheap and readily available components to assemble a configuration comparable to a mainframe, without having to give all your money to the company lovingly known as "Infernal Bloody Monopoly".  However, Oracle pricing threw a wrench into this idea. Now, a mainframe will be cheaper than a RAC.

First and foremost, RAC is a data warehousing technology. The purpose of RAC is to get all the nodes working in unison on a large query which would probably take days to resolve before. If you try RAC with OLTP, you'll have to setup singleton services, running on all nodes or cluster wait will kill you. Things seem to be a bit better with X9, which has 100Gb/sec Mellanox interconnect and RDMA but even with all those hardware bells and whistles, it's still not a single machine. There is a competing technology called NUMA, and Oracle is well aware of it. The largest SPARC servers were NUMA machines, NUMA combines the fault tolerance of RAC with the single system image and is, in my humble opinion, far easier to maintain than RAC.

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
https://dbwhisperer.wordpress.com

--
http://www.freelists.org/webpage/oracle-l