Re: Wildfire/Oracle/NUMA/QBB affinity on OpenVms/Oracle73

Rob Young wrote:
>

Only you Rob could answer a query about someones performance issues on a current brand spanking new WildFire with an advert for a processor that is currently not available running in the machine that will replace the posters brand spanking new WildFire.

They havn't had it that long and allready its out of date !!

This sort of response is could have been taken directly from the Microsoft book of marketing answers when people complain about MS's latest product, what do they do sell them the next new product.

Why not try a more sensible suggestion:

1. Use OPS
2. Upgrade to a more NUMA friendly version of Oracle like 8.1.7
3. Get Compaq to replace the WildFire with a GS140 it will be cheaper and it will probably be faster.

	With the money the poster saved
	he could have bought you a beer
	and even splashed out on nibbles.

Regards
Andrew Harrison
Enterprise IT Architect

> In article <3a7fb92b.2226779_at_news-server>, nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto) writes:
> >
> > With new releases for that specific h/w, it's possible the problem
> > will go away, although I doubt it will be a complete solution.
> >
>
> Don't overlook hardware helping out too. Some people get
> antsy when futures are trotted out. But some folks make
> decisions based on futures (Sandia/Celera, Los Alamos, European
> SuperComputer Centre) so we shouldn't be that nervous.
>
> This afternoon, the following presentation takes place:
>
> http://www.isscc.org/isscc/2001/ap/ap/AP_forWeb_Nov16.pdf
>
> 15.6 A 1.2 GHz Alpha Microprocessor with 44.8 GB/s Chip
> Pin Bandwidth
>
> A. Jain, et al. Feb 6.
> 4:15 p.m.
> Compaq Computer Corporation, Shrewsbury, MA
>
> A 4th generation Alpha microprocessor running at 1.2 GHz delivers up to
> 44.8 GB/s chip pin bandwidth and dissipates 125W at 1.5V. It contains a
> 1.75MB 2nd level write-back-cache, two memory controllers supporting 8
> Rambus(tm) channels running at 800 MB/s, four 6.4 GB/s inter-processor
> communications ports, and a seperate IO port capable of 6.4 GB/s. The chip
> measures 21.1x18.8 mm2 and contains 130M transistors.
>
> What interests me more than bandwidth is latency. Latency is
> the issue (as everyone has bandwidth or soon to, i.e. Power4,
> Ultra III) now. From what we see, latency gets much better
> with EV7, this link is no longer there:
>
> http://www.alphapowered.com/alpha21364.ppt
>
> But if it was there you would notice that local latency is
> "30 ns CAS latency pin to pin" (slide 17) and L2 latency is
> "12 ns load to use" (slide 16) with "15 ns processor to processor
> latency" (slide 18, i.e. remote memory routing) so it *appears* if the
> memory is two hops away , you may be looking at < 150 ns memory
> access if the page is open (sure, add a few dozen nanoseconds for
> routing , whatever).
>
> Point is latency for Alpha gets MUCH better and NUMA *should*
> become less of an issue for future Alpha hardware. Perhaps they
> talk more about latency this afternoon.
>
> Rob
 

-- 
Andrew Harrison
Enterprise IT Architect