Change column width of show parameter in SQL Plus
column NAME_COL_PLUS_SHOW_PARAM format a30
column VALUE_COL_PLUS_SHOW_PARAM format a30
SQL> show parameter memory
NAME_COL_PLUS_SHOW_PARAM TYPE VALUE_COL_PLUS_SHOW_PARAM
------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
memory_max_target big integer 5G
memory_target big integer 5G
shared_memory_address integer 0
No comments:
Post a Comment