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;
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;