-
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
-
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
-
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.
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|