------------------------------     -----------------------     ----------------------------------------------     ---------------------
| gv$session  inst_id        | <-> | gv$process  inst_id |     | fnd_concurrent_requests  requested_by      | <-> | fnd_user  user_id |
|             paddr          | <-> |             addr    |     |                                            |     ---------------------
|                            |     |             spid    | <-> |                          oracle_process_id |
|                            |     -----------------------     ----------------------------------------------
|                            |
|                            |     -------------------------------
|             inst_id        | <-> | gv$sort_usage  inst_id      |
|             saddr          | <-> |                session_addr |
|             sql_address    | <-> |                sqladdr      |
|             sql_hash_value | <-> |                sqlhash      |
|                            |     -------------------------------
|                            |
|                            |     ----------------------
|             inst_id        | <-> | gv$sql  inst_id    |
|             sql_address    | <-> |         address    |
|             sql_hash_value | <-> |         hash_value |
|                            |     ----------------------
|                            |
|                            |     ----------------------------
|             inst_id        | <-> | gv$session_wait  inst_id |
|             sid            | <-> |                  sid     |
|                            |     ----------------------------
|                            |
|                            |     ------------------------------
|             inst_id        | <-> | dba_jobs_running  instance |
|             sid            | <-> |                   sid      |
|                            |     ------------------------------
|                            |
|                            |     ---------------------------     ------------------------     -------------------
|             inst_id        | <-> | gv$transaction  inst_id | <-> | gv$rollstat  inst_id |     | v$rollname      |
|             taddr          | <-> |                 addr    |     |                      |     |                 |
|                            |     |                 xidusn  | <-> |              usn     | <-> |             usn |
------------------------------     ---------------------------     ------------------------     -------------------