cancel
Showing results for 
Search instead for 
Did you mean: 

Delete Parameter from Database profile

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

stefan_koehler
Active Contributor
0 Kudos

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

Former Member
0 Kudos

Thansk very much Stefan.

Regards.