Oracle Database Discussions

Hi,

I need to set the value for utl_file_dir and we are using spfile in the DB.
Is a bounce of the DB required to set this value?

I used this command alter system set utl_file_dir='/opt/oracle/product/10.2.0/cds/interface' scope=spfile;

System altered.
But still the value shows as null.

SQL> show parameter utl_file_dir

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
utl_file_dir string

Please advise.

Regards,
Narayan