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

This entry was posted on October 16, 2011 at 1:12 AM and is filed under Admin. Tagged: , , . You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

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

  1. How to resolve ORA-00490 error? « Pavan DBA's Blog said

    October 17, 2011 at 11:43 PM

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

    Reply

  2. Ashima said

    October 17, 2011 at 1:02 AM

    Hi Pavan,

    Thanks for such an informative article.

    Reply

Leave a Reply

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

Gravatar
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 )

Cancel

Connecting to %s

«
»
 
Follow

Get every new post delivered to your Inbox.

Join 1,477 other followers