V$BGPROCESS and V$SESSION
Rich VApr 12 2010 — edited Apr 20 2010This is on 10g.
V$BGPROCESS displays information about background processes
V$SESSION has some rows representing background processes.
What is the difference between two ?
Am I correct in understanding that ; v$bgprocess contains total allocated processes whereas, v$session represents total runtime processes on that instance?
That being said, for example, if there are 10 sessions, all 10 sessions will have same number of bacground processes. Is that true?
To explain further, say if v$session displays DBW0 and DBW1, it means two instance of DBWR processes are running for this instance. But if v$bgprocess has DBW0.. DBW9 processes, that means, you can maximum have 9 DBWR processes on that instance.
Please concur if above is correct.
Thanks
R
t