Poor Performance on SAP

[manthana_c]

Dear gurui:

When I run every T-code , it took around more than 10 seconds.

Anything that I can deactivate like system log or any adding cache. please advise the menu.

Thanks in advance.

[Former Member · Accepted solution]

Hi,

If the entire system is slow, then you have to look at hardware resource utilization first.

Is CPU being utilized more than 90%. Check main memory utilization.

Check SAP and Oracle parameters are set as per SAP's standard or not.

There are many notes available in the marketplace.

Revert with your details of OS, Database and findings etc.

Br.

Venky

[manthana_c · Accepted solution]

OS = Windows 2003

DB= Oracle 10g

Can you let me know what is the parameter that I should set for Oracle please?

Thanks in advance.

[Former Member · Accepted solution]

Hi Varun,

You should refer to the following SAP note.

Note 830576 - Parameter recommendations for Oracle 10g

There is a script attached at the end of the note 1171650.

Copy the script parameter_check_102.txt

Login to SAP and run SE38

Run Report rsoradjv, paste the script and click on execute.

It should display the parameter recommendations as per SAP.

Restart the system after making the changes.

BTW, what is the exact patch level of Oracle your system is on?

Which SAP system is this?

Br,

Venky

[manthana_c · Accepted solution]

Hello Venky:

my SAP system is new , just use for 2 months.

I install oracle and patch 10.2.0.2.0.

one thing to confirm before I run the report RSORADJV is this program is for checking first , it not auto update until I confirm isn't it?

[manthana_c · Accepted solution]

Hello Venky:

I have try detail analysis via ST04

data buffer = 212992 kb not sure recommended size , I not found on notes

share pool = 212992 kb notes 830576 recommend 400 mb

log_buffer = 2836 kb not sure recommended size , I not found on notes

are these parameters are major one that I should increase the size first? and how to do.

please advise the key parameter I should take a look and how to change.

I still worry if run RVORADJV because there are too many parameters I not familiar.

[Former Member · Accepted solution]

Tune SAP Memory and Oracle parameters to fix the performance issue.

Implement the parameters as per below note and let us know

88416 Zero administration memory management for the ABAP server (SAP Memory Tuning)

830576 Parameter recommendations for Oracle 10g

[manthana_c · Accepted solution]

Hello Arjun:

I 'd like to implement notes 88416 which t-code I should use.

I go to rz10 but which profile to select.

Thx in advance.

[Former Member · Accepted solution]

Goto RZ10 --> F4 -->select Instance profile which shows like <SID>_DVEBMGS<nr>_hostname and select "Extended Maintenance" and click on CHANGE button and modify / add the parameters.

[manthana_c · Accepted solution]

Hello Venky:

I have try RSORADJV and paste the parameter_check_102.txt

when execute the message said syntax error like this.

Syntax error in generated program: Generation error.

Source code

PROGRAM EXECSQL.

TYPE-POOLS: slis.

TYPES: BEGIN OF ty_data,

NAME(80) TYPE C,

RECOMMENDATION(80) TYPE C,

I(80) TYPE C,

U(80) TYPE C,

REMARK(80) TYPE C,

SET(80) TYPE C,

IS_VALUE(80) TYPE C,

SHOULD_BE_VALUE(80) TYPE C,

ID(80) TYPE C,

INST_ID(80) TYPE C,

END OF ty_data.

TYPES: ty_datatable TYPE TABLE of ty_data.

DATA: gs_data TYPE ty_data.

DATA: gt_data TYPE ty_datatable.

FORM read_data.

DATA: l_except TYPE REF TO cx_sy_native_sql_error .

DATA: l_rc TYPE i.

DATA: l_text TYPE string.

DATA: l_text2 TYPE string.

REFRESH gt_data.

EXEC SQL.

open crsr for

select

name,

substr(order_recommendation,3) recommendation,

substr(flags,1,1) "I",

substr(flags,2,1) "U",

remark,

"SET",

is_value,

should_be_value,

substr(order_recommendation,1,1) "ID",

inst_id

from

(

select

decode(substr(c.name,1,3),

'***',-1,c.inst_id) inst_id,

[manthana_c · Accepted solution]

I try F4 but I not see any profile name like my SID or contain my hostname??

[Former Member · Accepted solution]

Looks like you haven't done post steps completely. In RZ10 --> in the menu click on Utilities -->Import Profiles -->of active servers.

Try to select the profile and modify or add the parameters.

[Former Member · Accepted solution]

Change the parameter_check_102.txt to parameter_check_102.SQL and store it in D drive likeD:\parameter_check_102.SQL and run as below

>sqlplus "/as sysdba"

>@parameter_check_102.SQL

[manthana_c · Accepted solution]

Hello Arjun:

while I import the log like this , is this error can ignore?

Complete check of instance profiles and a default profile

Log for default profile , Single check

Profile name : DEFAULT

Physical profile name : C:\usr\sap\MNP\SYS\profile\DEFAULT.PFL

Check on server : rilakkuma_MNP_00

j2ee/dbname changes not permitted (in red)

[Former Member · Accepted solution]

You can ignore it

[manthana_c · Accepted solution]

I still cannot run e:\@parameter_check_102.sql

it just prompt notepad ??

and according to note 88416

rdisp/ROLL_MAXFS | [BE] * 100

[BE] = maximum possible number of users (calculated from [PM])

what is the formula to calculate from PM??? I cannot find in note??

my PM = 512

[PM] = value of the profile parameter PHYS_MEMSIZE (standard

value=[HS])

Edited by: Manthana99 on Feb 21, 2012 12:47 AM

[manthana_c]

can anybody let me know how to implement 830576

right now note 1171650 can help note#830576

but I cannot run via se38-RSORADJV message "The length of the current statement is greater

than the maximum statement length"

please advise any other way to change parameter in oracle for notes 830576 .

[Former Member]

Hi Manthana,

You can try to paste and execute the sql script attached to the note in ST04 -> Addition Function -> SQL Editor

If this doesn't help, connect the database to your Solution Manager system in DBACOCKPIT and execute the script.

The script is pretty straight forward and can help you setting consistent parameters.

Br,

Venky

[manthana_c]

I successful run script via sqlplus

but the script just output what is ok or not ok.

is the script auto update system paramater or not.

and how to update system paramater if the script recommend to do.

thx in advance.

[Former Member]

Hi,

is the script auto update system paramater or not.

No, The script just shows the SAP recommended values for all of Oracle parameters. It will not update anything in pfile or spfile.

You as an administrator of the system have to do that.

and how to update system paramater if the script recommend to do.

This is nicely explained in orafaq

http://www.orafaq.com/node/5

Understand what is PFILEs and SPFILEs

You should use the command alter system for changing the parameter.

For e.g.

ALTER SYSTEM SET open_cursors=300 SCOPE=SPFILE;

Please revert if you need more clarification.

Br,

Venky

Edited by: Venkatesh Pydi on Mar 4, 2012 4:41 AM

[Former Member]

Hi,

Is this a new system ? Or were any patches / updates applied ?

If yes, please make sure that you have run SGEN.

Also make sure that SAP and DB related parameters are set correctly and that standard jobs like DB stats are scheduled and running correctly.

Also check and analyze performance related issues from ST03N, ST02, ST04, etc.

Hope this helps.

Regards,

Varun