Skip to Content
avatar image
Former Member

Oracle parameter change

Hi Friends,

We have to change the parameter db_cache_size in our oracle 10g database.

What is the unit (kb, mb or gb) of value to be assigned. We have to increase it upto 16gb currently it is 8 gb.

What are the precaution should be taken to change this parameter, application down , user lock etc.

Please help me ?

Regards

Ganesh Datt Tiwari

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 07, 2011 at 09:24 AM

    You can see the current unit that is in use in the initSID.ora file.. If noting is mentioned m/g, then bytes are being used..

    The only thing you have to take into account, is that sufficient physical memory is available on the server.

    Kind regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Dear Friends,

      Thanks to all of you for your valuable help to me.

      My issue has resolved.

      I have used command # alter system set db_cahe_size=16G scope=spfile;

      Regards

      Ganesh Datt Tiwari

  • avatar image
    Former Member
    Jan 06, 2011 at 02:06 PM

    >

    > Hi Friends,

    > We have to change the parameter db_cache_size in our oracle 10g database.

    >

    > What is the unit (kb, mb or gb) of value to be assigned. We have to increase it upto 16gb currently it is 8 gb.

    Hi

    Look at the documentation:

    http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams043.htm

    there you can see that you can specify it in several units

    > DB_CACHE_SIZE = integer [K | M | G]

    >

    >

    > What are the precaution should be taken to change this parameter, application down , user lock etc.

    It depends (as usual)

    I prefer to change the parameter in the spfile and then stop SAP and restart oracle.

    Keep in mind other parameters that you may have set (like SGA_TARGET and SGA_MAX_SIZE) as you may have to modify them aswell

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2011 at 07:57 AM

    What are the precaution should be taken to change this parameter

    Make sure you have 8gb memory free on the server 😉

    Kind regards, Michael

    Add comment
    10|10000 characters needed characters exceeded