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.
Perhaps you should take a look at your alert log.
I pulled this from the alert log of one of my databases.
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
you can also select from v$bgprocess
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.
Try hard to get what you like OR you will be forced to like what you get.
Click Here to Expand Forum to Full Width