We are on 184.108.40.206.0 on Win2K.
Currently, COMPATIBLE para. is set to 8.1.7.
What will be the effect (good & bad) if I change it to 220.127.116.11.0?
Thanks in Adv.
To handle yourself, use your head. To handle others, use your heart
That means you are using Release3 binaries with Release 8170 features usage. I don't think it make much difference changing it to Release3 with the exception of Optimizer. How Optimizer behaves depends on what were the improvements on Optimizer from 8170 to 8173 and your queries.
There will not be significant changes, you can test it if you have test instance if not go ahead and change it and be ready for 8174 upgrade if at all any consequences by changing this parmaeter. Oracle will be suggesting you to go to 8174 anyway.
Click Here to Expand Forum to Full Width