on 06-25-2010 7:14 AM
Hi,
here in st04 transaction i am getting DATABASE BUFFER rate is 70%, so i want to set it is upto 90% . so plz let me know that which parameter i have to change .
Regards
subhani.
DB_CACHE_SIZE
Check note https://service.sap.com/sap/support/notes/830576 for Oracle 10G
and https://service.sap.com/sap/support/notes/124361 for 9i and 8
Regards
Anindya
Edited by: Anindya Bose on Jun 25, 2010 1:36 PM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi subhani,
take a look on http://download.oracle.com/docs/cd/B14117_01/server.101/b10752/memory.htm#48859
There are some sql statements to get system suggested cache sizes.
Regards
Franz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
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.