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!

Data Dictionary views

569820Feb 15 2011 — edited Feb 16 2011
Hi,

I have a question about relationship between data dictionary views "v$session" "and v$process". I know that v$session has one record for each user connection, and v$process has one record for each oracle process. Now since one user session can run multiple processes, I was guessing that for one record of v$session, there can be multiple records in v$process. That is, there is a parent child relationship, with v$session being the parent.

But once I saw in some Oracle documentation that one session is owned by a process!!! meaning each record in v$session has a reference (paddr column) to the process who owns the session. This statement confused me!!

Can anybody tell me the correct relationship between these 2 view? who is parent, who is child? or is there a one to one relationship?

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 16 2011
Added on Feb 15 2011
5 comments
301 views