Question: what is gv$session in oracle?
Answer: 1 - V$session is used on standalone database, an gv$session (g=global) is used mostly on RAC environments, showing all sessions on each node. 2 - maybe with something like this.