Check

Current Session

SHOW PARAMETERS

SELECT * FROM V$PARAMETER;

SELECT * FROM V$PARAMETER2;

Instance

SELECT * FROM V$SYSTEM_PARAMETER;

SELECT * FROM V$SYSTEM_PARAMETER2;

Server Parameter File

SHOW SPPARAMETERS

SELECT * FROM V$SPPARAMETER;