I couldn't have said it better myself. That's a GREAT question.Does it really happens?
Yeah, I redacted that one. Do you find the other evidence credible?so I'm afraid the whole example is a bit suspect.
Sorry, Richard, I'm not biting. At best, your demo is a rule-of-thumb, but not a proof, by any definition.demo to prove it one way or the other yourself.
Hi DonSorry, Richard, I'm not biting. At best, your demois a rule-of-thumb, but not a proof, by any
Your test case shows only one of zillions of possible
Don't you agree that it's reckless to generalize from
a single test case, especially when exceptions are
known to exist?
OK, I'll buy that, in theory, but what about the TCP standard? The TPC benchmarks are 100% reproduceable, and you are free to re-run their TCP-C and TPC-H benchmarks and prove them wrong.It's not a single test case or demo, it's an approach that can generate as many test cases as you like
No, it cannot "prove" anything, IMHO. There are too many interviening factors (init.ora parms, I/O sub-system, etc). In my world, we conduct a full test using a real-life workload, the only truly representative measure, IMHO.Here's a method or approach to prove (or otherwise) a piece of Oracle behavior
No, I respectfully disagree. Do you really think that shops just rock-and-roll in production without testing? Now, that would be reckless! I ALWAYS insist on complete load testing whenever a client considers implementing multiple blocksizes.You have proven to be "reckless" in relying on Robin's simplistic and erroneous test case for years.
That's a bit presumptious. How would you know what I do at a client site?I'm afraid you're the one who relies on single, simplistic test cases
And that's OK! We come from very different worlds, and we each have a fresh (and largely valid) perspective on this issue . . . .This is why we fundamentally differ you and I.
Paying a million for a server is not that rare. Most large shops spend millions on their hardware, it's not that unusual, especially for shops that support thousands of concurrent users.There would be a handful -really, just a handful- of businesses on the planet that genuinely (a) have that much money to spend
If you say so . . . .But I've never worked for such a company and I doubt 99%+ of DBAs ever will either.