v$system_parameter

Difference between v$system_parameter and v$parameter

June 15, 2020 by techgoeasy Leave a Comment

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 […]