Parameter Setting Precedence.

posted Apr 28, 2017, 4:02 PM by Sachchida Ojha
Q. If you set the same parameter setting at multiple level for example  system, database, role, session level which one takes the precedence.
Ans: If a parameter is set at multiple levels, the most granular level takes precedence. For example, session overrides role, role overrides database, and database
overrides system.