I read about the parameter _enable_schema_synonyms which allows a user to create schema synonyms. However, to enable the parameter it would require a DB reboot.

Are there any negatives to enabling this parameter? Is it worth the reboot?


1 Answer 1


Unless it's an officially documented parameter, you shouldn't use it unless directed to by Oracle support. (Alex Poole)

Setting and using undocumented parameters unless Oracle Support specifically tells you to is almost always a bad idea -- they're undocumented for a reason. Doing so as a junior DBA with no senior DBA available is a really, really bad idea because you're going to be stuck when something goes south. A couple of issues with the parameter are shown here but there are likely others. (Justin Cave).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.