Oracle Configuration
Check
Check
Current Session
Current Session
SHOW PARAMETERS
SELECT * FROM V$PARAMETER;
SELECT * FROM V$PARAMETER2;
Instance
Instance
SELECT * FROM V$SYSTEM_PARAMETER;
SELECT * FROM V$SYSTEM_PARAMETER2;
Server Parameter File
Server Parameter File
SHOW SPPARAMETERS
SELECT * FROM V$SPPARAMETER;
Recommended Configuration
Recommended Configuration
Performance
Performance
Parameters
Parameters
Tablespaces
Tablespaces
Other
Other
Container Database/Pluggable Database
Database Migration Assistant for Unicode
Scripts
Scripts
Bibliography
Bibliography
11.1https://docs.oracle.com/cd/B28359_01/server.111/b28310/create006.htm#ADMIN11124 (Viewing Parameter Settings)