Note 830576 - Parameter recommendations for Oracle 10g
hi all DBA experts.
I am not good familiar with Oracle database while i read a Note 830576 - Parameter recommendations for Oracle 10g. in which SAP General Recommendation:
You should delete obsolete initialization parameters from the profile. To determine which obsolete parameters are currently set, proceed as follows: SQL> SELECT NAME FROM V$OBSOLETE_PARAMETER WHERE ISSPECIFIED = 'TRUE';
when i execute above command then result is no rows selected
while there are many parameters in above SAP Note which are already obsolete and not set in initSID.ora file.
for exp. the parameter OPTIMIZER_INDEX_COST_ADJ is showing
#### OPTIMIZER MODE #optimizer_index_cost_adj = 10
as you know that this parameter is very important regarding System Performance.
now please guide me . I have to set these parameter or no need while there is not showing any parameters against obsolete command.
waiting you valuable reply.
Orkun Gedik replied
If you applied all the patches and parameters and still having the performance problem, you can open another ticket by referring existing OSS ticket.
"Fetch" process does not contain a SQL statement. Find the related "Open" process, in order to identify SQL statement. There must be a "open" or "reopen" process in the list. If not prepare a new analyze for VA02.
By the way, could you identified the SQL statement that cause to the performance problem on ST05?
Additionally, I prefer to execute the "10204_Patch44_MSWIN-x86-64.zip" patch, at the end of the list.