Re: Intel processor performance

The answer is one HUGE  "It depends".
on a whole buncha things....
What is being done - and how.
What the current bottle necks are - although you don't indicate there are any.

So, if/when things change where do you expect/hope the changes will be ? i)  More web site hits - obviously.
ii) Scans of larger tables - maybe, if you are expanding a catalogue or set of customer accounts.
iii) More table joins - and bigger tables being joined - probably, if you're growing a business.
iv) through n)  it goes on and on...

At some point just start taking measurements and understand if I/O, memory, CPU or plain ole Oracle tuning are limiting throughput.

Its a(nother) never ending quest.

\R
 
 

Martin Kleinman wrote:

> I've got a question about Oracle 8.1.7 + OAS 4.0.8.1 And processor
> performance.
>
> I'm running the database and the webserver all one 1 machine. I know this
> isn't the perfect situation but it works without any problem.
>
> The specs of the machine
>
> Asus P2B
> Celeron 400a
> 512MB memory
> 1x 1.1gig hdd for boot (WIN NT)
> 1x 20 gig hdd (split into 3 partitions, resp d: ORANT, e: OAS , f:
> swapspace)
>
> The question I've got how does the processor impact the performance of the
> machine?
>
> Does it matter much that its only a Celeron 400 with 128kb L2 Cache? Will a
> P2 400 (with 512kb  1/2 speed L2 Cache) improve performance a lot?
>
> What If I install a Celeron2 566 or higher (maximum supported by the
> motherboard, it doesn't support the p3, at least not that I'm aware of).
>
> Is Oracle highly dependend on the speed of the L2 Cache? Or is it highly
> dependend of the speed of the memory (thus a 100Mhz bus processor, P2/P3)??
>
> I suspect the latest but I'm not sure 100%
>
> Is there anyone who has some experience with this?
>
> TIA
>
> Martin Kleinman,
> Webdeveloper Desyde BV, Baarn, The Netherlands
Received on Thu Apr 05 2001 - 07:08:08 CDT