Difference between v$parameter and v$spparameter

PROBLEM:
What are the differences between v$parameter and v$spparameter?

SOLUTION:

• V$PARAMETER - It displays the information about initialization parameters that are currently in effect for the session.
• V$SPPARAMETER - It displays the information about contents of the server parameter file. If a server parameter file was not used to start the instance, then ISSPECIFIED column contains FALSE value

SELECT name, value FROM v$spparameter

WHERE name LIKE '%mttr%';

SELECT name, value FROM v$parameter

WHERE name LIKE '%mttr%';

alter system set fast_start_mttr_target = 100 scope = spfile ;

SELECT name, value FROM v$spparameter

WHERE name LIKE '%mttr%';

SELECT name, value FROM v$parameter

WHERE name LIKE '%mttr%';

-- View only used parameters from the spfile :

select count(*)

from v$spparameter

where ISSPECIFIED <> 'FALSE'

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!