Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
Showing results for 
Search instead for 
Did you mean: 

Upgreade Oracle from 8.0.5 ->8.1.7

Sebastian Galeski_1
Trusted Contributor

Upgreade Oracle from 8.0.5 ->8.1.7

Hello guys:
there is SAP/R3, big Oracle data base ~1.8TB in MC/SG 2 node cluster, after upgreade from oracle 8.0.5 to 8.1.7 respoonse time for SAP/R3 user is almost 2 times more. Anybody of You had such upgreade and can show important thing for 8.1.7 (parameters in iniSID.ora) which have to be change after such upgreade. Maybe You have some idea where to look in.

regards seba

Re: Upgreade Oracle from 8.0.5 ->8.1.7

Surely you would be better asking this of SAP/Oracle?
They know these applications far better, and have a recommended patch list etc.
My house is the bank's, my money the wife's, But my opinions belong to me, not HP!
T G Manikandan
Honored Contributor

Re: Upgreade Oracle from 8.0.5 ->8.1.7

fact: Oracle Server - Enterprise Edition 8.1
symptom: Slow down off application after upgrade
cause: Application has been tuned for old version of RDBMS. New optimizer
of new RDBMS generates different execution plans.


Set value of old RDBMS version in init.ora parameter OPTIMIZER_FEATURE_ENABLE.

E.g. If there was upgrade from RDBMS 8.0.5 to RDBMS 8.1.7. then