Skip to Content
avatar image
Former Member

Dynamic SGA Activation

Hi All,

I read somewhere that to check whether Dynamic SGA is activated or not you have to check the following;

DB_BLOCK_BUFFERS is set to some value and DB_CACHE_SIZE is set to 0 means Dynamic SGA is not activated.

Am I correct? Is there any other way to check whether it is activated or not?

Regards,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Apr 03, 2009 at 02:44 AM

    Hello Arvind,

    first of all,are using SQL server?

    if yes,there is no concept of SGA in SQL server,SGA is the concept only in Oracle database.,so this should be posted in Oracle forum

    SGA is a feature of Oracle starting from 9i,so it is not that you have to activate SGA,it is already activated since Oracle 9i

    Rohit

    Add comment
    10|10000 characters needed characters exceeded