How to know database initialization parameter in oracle 1)SHOW PARAMETER option: If you
use SQL*Plus then you can use SHOW PARAMETER parameter_name to display
the values of parameters currently in use. Note that with toad or tora
you can't use it as it is SQL*plus option.
SQL>SHOW PARAMETERS sga_target;
NAME TYPE VALUE
------------ --------- --------- ------ ----------- ------------ --------- ---------
sga_target big integer 160M
2)Query from V$PARAMETER: You can query value column of this view to display the values of parameters currently in effect.
SQL> SELECT VALUE FROM v$PARAMETER WHERE name='sga_target' ;
VALUE
------------ --------- --------- --------- --------- --------- -
167772160
3)Query from V$PARAMETER
