Order of Mandatory background process
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Order of Mandatory background process

  1. #1
    Join Date
    Jul 2008
    Posts
    16

    Post Order of Mandatory background process

    What is the order, in which mandatory background process(SMON, PMON, CKPT, DBWn, LGWR, ARCn and RECO) starts while database is starting.

    with regards
    Prthvira
    INDI

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,999
    Perhaps you should take a look at your alert log.
    I pulled this from the alert log of one of my databases.

    Code:
    PMON started with pid=2, OS id=2230
    PSP0 started with pid=3, OS id=2232
    MMAN started with pid=4, OS id=2234
    DBW0 started with pid=5, OS id=2236
    LGWR started with pid=6, OS id=2238
    CKPT started with pid=7, OS id=2240
    SMON started with pid=8, OS id=2242
    RECO started with pid=9, OS id=2244
    CJQ0 started with pid=10, OS id=2246
    MMON started with pid=11, OS id=2248
    MMNL started with pid=12, OS id=2250
    this space intentionally left blank

  3. #3
    Join Date
    Oct 2008
    Location
    Johannesburg,South Africa
    Posts
    3
    you can also select from v$bgprocess

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    If the database is 9i, v$bgprocess will not tell you the order how the back ground processes are started. Alert log is the best place to find.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Jul 2008
    Posts
    16
    thanks for kind response
    Prthvira
    INDI

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width