The only way you can do it is change the parameter in the init.ora and bounce the database.