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. |