Log_buffer Parameter is not appering in init<sid<.ora file
we have 10g(10.2.0.2) and 9i systems on HP unix. When we give show parameter log_buffer, it displays 3000000. But, when we take create pfile from spfile , this log_buffer parameter is not appering. Question is why? So, suppose i started modifying certain parameters in init.ora file and then I started the instance , created the spfile , and again open the instance with spfile , so my old value is gone, and default value will come 512 KB or 128*cpu.
Is it a exepected behaviour? Or any issue. This is on both 9i and 10g.
Regards
Nikhil Wani