Oracle Database parameter

[Former Member]

Hi ,

Setting oracle parameter according to note 1431798.

In this not there  is parameter _FIX_CONTROL which is having values which need to be set.

But in my initsid.ora file there is no  _FIX_CONTROL parameter .Do i need to set manually?

How to calculate these two parameter weather these value is right or not?

db_cache_size=9097067888

shared_pool_size=9097067888

Any other parameter which is important for performance of database?

Regards

Adil

[former_member188883 · Accepted solution]

Hi Adil,

You can use db02 - >SQL editor.

Copy the script attached to SAP note 1171650 and execute

Download the contend into excel

Check the list of parameters which needs to be implemented.

Hope this helps.

Regards,

Deepak Kori

[Former Member · Accepted solution]

Hi Deepak Sir,

Having Java Instance , So i cant execute db02.

So i need to set fix control parameter manually.

Thnx every one for ur suggestion..

Regards

Adil

[Former Member]

Hi,

You have to set to get good performance , but Set accordingly with SBP you are having , Do you know what SBP you are having in Oracle 11G?

Other wise it can give you the negative effect also.

RK

[former_member661927]

Hi Adil.

Is very important to get some information to tuning you database. I strong recommend you to collect a EarlyWatchAlert Report and analyse it. After this you can determine the best way to tuning you environment. Changing only theses parameters may be not give you the expected results

Change parameters to gain performance depends on each environment and individually issues and bottlenecks.

If you have experienced a low performance with I/O may be you have to check the File System DB Block, distribution of datafiles an etc.

db_cache_size depends of you available memory.

Regards

[Reagan]

If the parameters are not set then you need to set them.

There is an Oracle DB parameter check script provided in this SAP note

1171650 - Automated Oracle DB parameter check

You may use to set the parameters.

Regards

RB