BW Performance tuning

[Former Member]

Hi Friends,

We are facing some performance down in our BW production server.

Database is Oracle 10g and OS is HP-UX 11 v2 and 960 GB database size.

What are the things can tuned in database ?

Thanks & Regards

Ganesh Datt Tiwari

[Former Member · Accepted solution]

Hi!

- Try to generate new statistics for tables in the database (not those owned by SYS or SYSTEM) I normally use compute (100%) for smal tables, 50% for medium, and 15-20% for big tables.

- Take those 5-10 most I/O expensive queries in the database and tune them.

- Check if shared_pool_size and db_cache_size are sized correct. If your SGA are bigger than 8-10GB, use huge pages.

Regards

Audun

DBA