Data Dictionary views
569820Feb 15 2011 — edited Feb 16 2011Hi,
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.