on 01-04-2015 3:35 AM
Hello everyone,
There's some database dump occurred after I upgrade our database to 11.2.0.4. I searched the relevant solution from internet and find the note 1431798 - Oracle 11.2.0: Database Parameter Settings which is recommended by SAP.
But I still confused about the parameter DB_CACHE_SIZE and pga_aggregate_target.
The current value is only 650M. Is it a little bigger for us? Sorry for my concern. It is our productive system. I have to be cautious and avoid any potential risk.
I am looking forward to your reply. Thank you in advance!
OS: windows server 2008 SP2 64bit
SAP: ECC6.0 EHP6 with cluster environment.
Database: oracle 11.2.0.4.
Physical memory: 49140MB for each note.
If you need more information, please feel free to let me know.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Chen
1. You can refer the SAP Note and perform the Oracle DB parameter.
1171650 - Automated Oracle DB parameter check
2. Refer the SAP Note
1739274 - Oracle 11.2.0: Database Parameter COMPATIBLE
BR
SS
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.