Change column width of show parameter in SQL Plus


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