Re: 9i server performance, 5 million hits per second?

chris wrote:
>
> Hi folks,
>
> I'm trying to get an idea on the performance of Oracle, or what might
> be required to get a performance in the region of 5 million queries
> per second, say simple select queries on an indexed table.
>
> I can foresee that there are many other variables involved here, but
> do you reckon it can handle it, any pointers on what sort of
> configuration?
>
> Sorry for the vagueness of this question, but I only need a vague
> answer!
>
> Cheers,
>
> Chris

Putting databases aside for a moment, I would doubt that even plain ol' memory could spit out reads at 5,000,000 per sec. Which means that if you can find a system that can read from memory at 'n' ops per second, you are going to need 5,000,000 / 'n' machines (and a perfect and balanced app) to support this...

Could be a struggle...

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."