on 07-02-2008 1:54 PM
Hi forums, I have a doubt. I have SAP BW 7.0 on Windows with Oracle 10.2.0.2.
The session of GoLive recommend me the following:
Parameter:
shared_pool_reserved_size
Description:
Part of Shared Pool for large statements
Current Value:
47799336
Recommended value:
Delete this parameter name and value from database profile
I delete this parameter from SPFILE, I shutdown the DB and restart ok.
Then I see that this parameter isn't in my SPFILE, but I consult this parameter with SHOW command and it has a value.
SQL> show parameter shared_pool_reserved_size
NAME TYPE VALUE
-
-
-
shared_pool_reserved_size big integer 8178892
Why this parameter is active still in oracle?
Is normal this action?
Regards.
CG
Hello Gustavo,
> Why this parameter is active still in oracle?
> Is normal this action?
Yes, this is completely normal, because of most / every parameter has its default value. So if you don't specify the parameter in the pfile/spfile, you have the default value which is set or calculated by oracle.
http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams196.htm#i1133799
Default value 5% of the value of SHARED_POOL_SIZE
Regards
Stefan
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 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
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.