performance tuning

[Former Member]

HI all,

We have a requirement of Performance tuning of Oracle DB for GRC application .any pointers related to that .Thanx in advance .

[Former Member · Accepted solution]

Had you created BITMAP index on table VIRSA_CC_PRMVL?

Are you using JCO connections?

How many thread and web services are defined in RAR configuration. It should not be more that 3 and 5 respectively.

Had you defined critical roles in RAR and enabled that they need not be analyised?

Regards,

Surpreet

[Former Member · Accepted solution]

Hi surpreet,

We are using Jco only but i didnt get your second question.Can you please explain me what you had asked .

[Former Member · Accepted solution]

These are configuration parameters of RAR. Go to Configuration Tab and there you will find performance tunning option. Inside this you will find these config parameters.

Regards,

Surpreet

[Former Member · Accepted solution]

we have done those also .....surpreet...

[former_member366047 · Accepted solution]

Ambarish-

Please refer to the "Performance Optimization Guide" in BPX for performance tuning tips. BPX is down right now. But you can do a search when it is back up.

Do you have a specific issue?

Ankur

SAP GRC RIG

[Former Member · Accepted solution]

management reports take too long to run ...

[Former Member · Accepted solution]

Mgt reports take time only when BITMAP index on table VIRSA_CC_PRMVL is NOT created.

Please cross check same with your DBA.

Regards,

Surpreet

[Former Member · Accepted solution]

hi surpreet ,

any other thing that needs to be taken care of ?at the database level

[hkaur]

Hi Ambarish,

Please refer the following SAP Notes for performance tuning of Oracle database(version specific):

1044174: Recommendations for CC 5.x running on Oracle 10G database

830576 : Parameter recommendations for Oracle 10G

823906 : Oracle 9 database parameters tuning

124361 : Oracle parameterization.

Hope this helps.

Regards

Harleen