Which process starts first when instance is started?


The first process that will be started when we start instance is PSP process. This is called PROCESS SPAWNER. This process is introduced in 10g and is responsible for creating and managing other oracle backgroung processes.
As the name specifies, this process can spawn so that you will see the process name as PSP0 in alert log file.