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

This is way too vague information to tell anything. You don't even specify how many RAM is in that box, or how many disks. First thing you should do is determine the database hitrate. If the hitrate is low, increase db_block_buffers, if the server doesn't start pagefaulting heavily look into enabling the lru statistics so you can know how much you will gain by increasing the db_block_buffers again. If you have no tuning experience, you might looking into download toad at www.toadsoft.com. Even the free version has monitor functions which will enable you to identify bottlenecks.

Hth,

Sybrand Bakker, Oracle DBA

Patrick Smits <smits188_at_zonnet.nl> schreef in berichtnieuws mXES4.127$43.4090_at_zonnet-reader-1...
> Hi,
>
>
> 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,
> sometimes). Now, apart from having the optimal datamodel (star schema),
 what
> 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