Oracle System Parameters

SQL> show parameter

SQL> show parameter xxx

 

select * from V$PARAMETER;
select * from V$PARAMETER2;

select * from V$SYSTEM_PARAMETER;
select * from V$SYSTEM_PARAMETER2;

select * from V$SPPARAMETER;

select * from V$NLS_PARAMETERS;