on 02-11-2011 6:32 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
very helpfull
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
My suggestion is - Check your EWA for the details from where the load is getting generated and what is hampering the system performance, what are the processes (Activities) utilizing much resources.
If you don't have the EWA option, Just log a call with SAP and let them involve in this issue.
OR
Update this message with more details (HW size, ST06 overview, ST04 overview, no of users etc)
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Have you installed a current Oracle patch set and checked that the parameters are set accordingly (SAP note 830576)?
You might also check st06 and analyse if there is any disk hot spot that results in poor performance.
Kind regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.