Re: Benchmarking Oracle on 2-processor HyperSPARC
Date: 1996/07/13
Message-ID: <4s8tdg$l6d_at_knot.queensu.ca>#1/1
> Does anyone on the net have a set of appropriate benchmarking tests
> ... that shows the superior performance of the multi-processor HyperSPARC
> module as compared to a single processor system?
i'm afraid i don't, but i've been looking for a cheap excuse to explore this issue in this forum. thanks. :-)
it's not obvious to me that an SMP (i.e. shared-memory) box ought to perform that much better for simple queries like, say,
SELECT * FROM tblMy5GigTable WHERE intMyMagicCookie = 12345 ; .
one of the claims one can read in the marketing literature is that such a query can be distributed across a gang of processors, with each one scanning a part of the large table. it seems to me that the processors will occupy themselves more with fighting for the memory bus than actually doing work. i wonder if many of these oracle SMP boxes aren't just really really expensive heaters.
is all. Received on Sat Jul 13 1996 - 00:00:00 CEST