How to fine the parameter value that differ between current value and spfile value

Query to find out the parameter that is different from current parameter value and SPFILE value, specifically focusing on identifying discrepancies that may impact system performance and configuration behavior. This involves comparing the current values loaded in memory against those specified in the server parameter file (SPFILE), allowing for a comprehensive analysis of settings that deviate from the standard configuration. By executing this query, administrators can pinpoint exact parameters that require attention, enabling more effective tuning and adherence to best practices in database management and performance optimization.

SELECT p.name,
       i.instance_name,
       p.value AS current_value,
       sp.sid,
       sp.value AS spfile_value      
FROM   v$spparameter sp,
       v$parameter p,
       v$instance i
WHERE  sp.name   = p.name
AND    sp.value != p.value;