Intel processor performance

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 - 15:18:39 CDT