Question: how to change utl_file_dir parameter in spfile?
Answer: first, in 11g the preferred way is to create a directory and not use utl_file. alter system set utl_file_dir='/appl/mydir','/appl/mydir2','/appl/mydir3' scope = spfile; if its the first way, redo it again the 2nd way as the first way is wrong (it will look the same in the v$table output, but its wrong).