Dynamic SGA Activation

[Former Member]

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,

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Sorry guys, By mistake i have posted this question here, thinking of SAP on oracle.

Sorry. thank Rohit