Pavan DBA's Blog

The DBA Knowledge Store

which process starts first when instance is started?

Posted by Pavan DBA on October 16, 2011


Long time back, I asked this question in my POLL and many of the DBA enthus choosed the option of SMON

But unfortunately, this is not the right answer (when considering 10g)

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.

More about PSP0 will be followed in my next article…..

Note : Please put your comments and also share this article by clicking share button below so as to spread the DBA knowledge

Advertisements

7 Responses to “which process starts first when instance is started?”

  1. Sheetal k said

    Hi pavan,
    Thanks for providing such as
    informations please
    try to post more………..

  2. Dharmendra said

    nice……… dude

  3. […] by Pavan Kumar on October 17, 2011 Yesterday in one post (https://pavandba.com/2011/10/16/which-process-starts-first-when-instance-is-started/) I explained about PSP0 process which is introduced in […]

  4. Ashima said

    Hi Pavan,

    Thanks for such an informative article.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: