show spparameters
I found one of the interesting features in SQL*Plus 11g for Oracle11g database when doing “help show” from the tool. SHOW SPPARAMETERS [parameter_name] Show specific parameters – SYSTEM @db11r1> show spparameters sga SID NAME TYPE VALUE ——– —————————– ———– —————— * lock_sga boolean * pre_page_sga boolean * sga_max_size big integer * sga_target big integer Show …