Param modification -ewa

[Former Member]

Hello gurus,

In my EWA report, I have in yellow some database parameters:

sortelimination_cost_ratio Efficient index with FIRST_ROWS and ORDER BY Please check SAP note 830576

optimizermjc_enabled Enable merge join cartesian Please check SAP note 830576

shared_pool_reserved_size Part of Shared Pool for large statements 173946175 Please check SAP note 830576

optimpeek_user_binds Bind value peeking Please check SAP note 830576

Except shared_pool_reserved_size, I cannot find any of them. And at current value field, it is empty.

Can you please advise what to do ?

Many thanks,

[Former Member · Accepted solution]

Add or delete them according to Note 830576 - Parameter recommendations for Oracle 10g

shared_pool_reserved_size should be removed according to this note and others are to be added. See the related notes mentioned corresponding to each of these three parameter in the note 830576

Thanks

[Former Member · Accepted solution]

Thanks,

You helped me out a lot today.

Cheers,

Jordan