Parameter Setting Precedence.

Post date: Nov 16, 2013 4:17:34 PM

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.