See initialization parameters from memory
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 …