Difference between v$system_parameter and v$parameter

In this post, we will discuss the Difference between v$system_parameter and v$parameter and other parameter view available in Oracle database. Lets first start with the definition of each of them V$PARAMETERIt displays the information about initialization parameters that are currently in effect for the session. V$SYSTEM_PARAMETERis the view which shows instance level parameters (and these are …

Difference between v$system_parameter and v$parameter Read More »