Hello Experts,I want to know that which background process create the memory in oracle when start the instance? If anyone from you guys knows it then please explain it here.
Thanks in Advance!
I guess server process.
After pmon authentication server process allocate memory.
Server process comes after instance start and not at the time of instance startup.it must be pmon but need to check by bringing db in nomount stage and parallaly check which process is running.
Startup nomount itself means background process started and memory structure allocated.
Server process. Oracle server process create SGA based on pfile.
Server process is responsible. Because server process is created once the instance is up.
Sign up for STechies
Ask Question From Our Experts