Skip to Content
avatar image
Former Member

DATABSE BUFFER VALUE

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 25, 2010 at 08:00 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 25, 2010 at 08:08 AM

    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

    Add comment
    10|10000 characters needed characters exceeded