Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

V$BGPROCESS and V$SESSION

Rich VApr 12 2010 — edited Apr 20 2010
This 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 18 2010
Added on Apr 12 2010
5 comments
3,485 views