How to increase poor Oracle-performance on AIX UNIX system?

Hi,

[Quoted] We run Oracle on a UNIX-machine. 233Mhz-processor, 36 Gig disk, 10 concurrent users tops. Tables: some have 10 mln records (datawarehouse). Performance is poor when querying with BusinessObjects (a query takes hours, [Quoted] sometimes). Now, apart from having the optimal datamodel (star schema), what [Quoted] will increase performance most likely most heavily? More internal memory? Higher processor-speed? Second processor? Network-hardware?

What is a 'normal' machine-configuration for a datawarehouse-machine with this number of users/data?

Can anybody tell me anything about how to analyze and increase query-performance professionally, Oracle- and hardware-wise?

Gr.,

Patrick. Received on Thu May 11 2000 - 00:00:00 CEST