on 02-20-2012 6:31 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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,
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)
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
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 .
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.