Home » SQL & PL/SQL » SQL & PL/SQL » gv$session vs v$session
gv$session vs v$session [message #236122] Wed, 09 May 2007 01:48 Go to next message
beetel
Messages: 96
Registered: April 2007
Member
If I want to see the active sessions/processes, what's the advantage of using gv$session instead of v$Session?? Our DBA prefers that we look at the gv$session to see the 'accurate' statuses of our processes. Doesn't v$session show this?

Thanks.
Re: gv$session vs v$session [message #236123 is a reply to message #236122] Wed, 09 May 2007 01:53 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
GV$ views.

If I read correctly then there's no difference between the two UNLESS you're using RAC. The GV$ variant retrieves the same information but adds an extra column (INST_ID). This column has no sense outside a RAC configuration. But again, that is if I read it correctly.

Here's what Jonathan Lewis has to say.

MHE

[Updated on: Wed, 09 May 2007 02:07]

Report message to a moderator

Re: gv$session vs v$session [message #236156 is a reply to message #236123] Wed, 09 May 2007 03:44 Go to previous messageGo to next message
beetel
Messages: 96
Registered: April 2007
Member
Thanks, that was helpful.
Re: gv$session vs v$session [message #236173 is a reply to message #236123] Wed, 09 May 2007 04:17 Go to previous messageGo to next message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Almost (??) all v$ views have their gv$ equivalents, or to be more precise v$ views are derived from gv$ views as one can see in v$fixed_view_definition.

Gints Plivna
http://www.gplivna.eu
Re: gv$session vs v$session [message #236210 is a reply to message #236173] Wed, 09 May 2007 05:45 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
gintsp wrote on Wed, 09 May 2007 11:17
Almost (??) all v$ views have their gv$ equivalents, or to be more precise v$ views are derived from gv$ views as one can see in v$fixed_view_definition.

Gints Plivna
http://www.gplivna.eu
you didn't read the links I posted, did you? The second one explains perfectly how the V$ views are built. No need to repeat it.

MHE
Previous Topic: Inserting null or space in DATE datatype
Next Topic: Query giving tabelar representation
Goto Forum:
  


Current Time: Sat Dec 03 20:10:58 CST 2016

Total time taken to generate the page: 0.06626 seconds