on 04-03-2009 2:54 AM
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.