Question:
Hi, experts,
I run CheckDB and got log below.
Anybody have idea what "HASH_JOIN_ENABLED" works for?
and I find no settings about the rest 3 error in init<SID>.ora. Did I miss any point?
Thanks
******
2003-09-04 08.01.31 Checking init.ora parameters ...
SAPDBA: Alert - Para met er OPTIMIZER_FEATURES_ENABLE is set to 8.1.7 (not to proper value 8.0.4)
SAPDBA: Alert - Parameter OPTIMIZER_INDEX_COST_ADJ is set to 100 (not to proper value 10)
SAPDBA: Alert - Parameter HASH_JOIN_ENABLED is set to TRUE (not to proper value FALSE)
SAPDBA: 3 out of 22 checked init.ora parameters are not set properly.
##############################################################################
******************************** Alert Summary ********************************
SAPDBA: Warning - Standard errors were detected
SAPDBA: Warning - Oracle profile parameters are not set properly.
For more details view CCMS transaction DB16
Answer:
Hi
Have a look at the following messege:
Posted: Wed Sep 03, 2003 9:02 am Post subject: What should these parametres set to?
Regards
Norr
Answer:
All this error is saying is that your settings in DB17 do not match your settings in init.ora.
To remove the errors from Checkdb go to DB17 OPTIMIZER_FEATURES_ENABLE, etc so they match your Oracle settings.
Determining if your Oracle settings are correct is a different question.