DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: COMPATIBLE parameter

  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    620

    COMPATIBLE parameter

    Hi,

    We are on 8.1.7.3.0 on Win2K.

    Currently, COMPATIBLE para. is set to 8.1.7.

    What will be the effect (good & bad) if I change it to 8.1.7.3.0?

    Thanks in Adv.
    Sam
    ------------------------
    To handle yourself, use your head. To handle others, use your heart

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    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.
    Reddy,Sam

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width