Is Overwriting the PFILE with the database on dangerous? Quick question that I cannot seem to find the answer to. I have some indexes that I want to rebuild at a scheduled interval, but they are fairly large and fill up the archive_log_dest_3 if I leave them unattended. So, I wrote a script that changes the dest_3 parameter in the pfile to a much larger mount point, and then changes it back afterwards, but the script overwrites the PFILE with an updated version. Would overwriting the PFILE while the database is on and doing these index rebuilds be dangerous or not recommended? Thanks!
Why do you need it? pfile is read only once when database starts.
Use spfile and alter system set parameter = value scope=memoryor alter system set parameter = value scope=both.