When running "show parameter sga" in sqlplus, only the sga parameters are being shown.
SQL> show parameter sga
NAME TYPE VALUE
------------------- --------------- -----------------
lock_sga boolean >
pre_page_sga boolean >
sga_max_size big integer >
sga_target big integer >
When doing Execute as a script > in Toad, all parameters shown, not only sga parameters.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center