SQL> show parameter sga
NAME TYPE
------------------------------------ ---------------------------------
VALUE
------------------------------
lock_sga boolean
FALSE
pre_page_sga boolean
FALSE
sga_max_size big integer
300M
sga_target big integer
300M
SQL> set linesize 200
SQL> show parameter sga
NAME TYPE VALUE
------------------------------------ --------------------------------- ------------------------------
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 300M
sga_target big integer 300M
SQL>
切忌用col name format a50 格式化,此格式化是无任何作用的,仅做记录一下