One of Oracle 11g’s new features is an ease of capturing the initialization parameter values currently in memory into a file. create pfile from memory; create spfile from memory; create pfile=’/tmp/cur_pfile.ora’ from memory; This comes in handy when you’d like to quickly verify changes especially after executing “alter system set” with scope=memory. It also lets …
You can change the width of the NAME, TYPE and VALUE of “show parameter” in SQL/Plus. 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 integer0 SQL> column NAME_COL_PLUS_SHOW_PARAM format A20 SQL> column TYPE format A20 SQL> column VALUE_COL_PLUS_SHOW_PARAM format A20 SQL> show …
Change column width of show parameter in SQL Plus Read More »
