Setting the utl_file_dir parameter in 10g
I want to set the 'utl_file_dir' parameter. From the internet I found that I can do it from OEM (the web-based one) by choose 'All initialisation Parameters...SPFile Tab...' (Refer to http://otn.oracle.com/obe/obe10gdb/bidw/blast/blast.htm#t0c).
However will this be temporary until the instance restarts? Also, will the change take effect after the restart of instance?