General
cancel
Showing results for 
Search instead for 
Did you mean: 

Best KERNEL settings for 2TB oracle datawarehouse(for better performance)

Quazi Abdur Rab
Occasional Visitor

Best KERNEL settings for 2TB oracle datawarehouse(for better performance)

Dear Gururs

Please suggest me what will be the best oracle releted and other performance related kernel parameter settings for the following configuration.
Hardware: HP rp7420 model 9000/800
OS: HP-UX B.11.11 U 9000/800
RAM: 32G
No Of CPU: 4
Oracle RDBMS Release: 9.2.0.8.0
Daily Growth:18GB
Current Size:2TB
Daily Loading Duration:7Hrs

Thanks & Regards
Quazi Abdur RAb
3 REPLIES
Sani
Frequent Advisor

Re: Best KERNEL settings for 2TB oracle datawarehouse(for better performance)

Hi ,

You may use "tune and tools" tool available from hp.It will set the optimised parameter value for oracle as per your h/w config .

Check the link

http://h20392.www2.hp.com/portal/swdepot/displayProductInfo.do?productNumber=Tune-N-Tools


Regards
Sani
Volker Borowski
Honored Contributor

Re: Best KERNEL settings for 2TB oracle datawarehouse(for better performance)

Hi,

well, get some system information on the 7 hours of loading.

Run a cpu watcher in this period like
vmstat 10 > cpu_usage.log

Do some "sar" calls as well, to get disk and memory utilisation information. If you have
glance, you will be able to get some fine
utilisation overview. If you do not have it,
I think there is a 60 day trial version available.

Create an oracle statspack report for some hourly stats-snapshots taken in between. This will be mainly information concerning stuff inside oracle.

This will be the data to work on and show you where to start with.
Are you doing the loads in parallel and to the same target tables or is it a single job?
What type are your tablespaces ?
Dictionary managed / LMTS / ASSM ?

Also some parameter information might be helpfull for us to give you good advice.

So a list of your kernel settings an a copy of your oracle configuration (init.ora).

Is there just the database on this server, or do you have to share resources to application-software elements as well?
What percentage of the resource would be assignable to this database?

Sorry for not being specific yet (too less data)
Volker
Volker Borowski
Honored Contributor

Re: Best KERNEL settings for 2TB oracle datawarehouse(for better performance)

Oooops, thread initiated in May 2008

Sani, why did you reply to this old one ???

You made me running the wrong way :-)
Never mind! Had no coffee yet, otherwise I
might have seen that earlier :-)

Volker