OraFAQ Forum: Server Administration » v$session view (merged 2)

Home » RDBMS Server » Server Administration » v$session view (merged 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

v$session view (merged 2) [message #521702]

Thu, 01 September 2011 05:03

hanner
Messages: 90
Registered: August 2011
Location: at HOME

Member

hi got this example from the website

SET LINESIZE 100
COLUMN spid FORMAT A10
COLUMN username FORMAT A10
COLUMN program FORMAT A45

SELECT s.inst_id,
s.sid,
s.serial#,
p.spid,
s.username,
s.program
FROM gv$session s
JOIN gv$process p ON p.addr = s.paddr AND p.inst_id = s.inst_id
WHERE s.type != 'BACKGROUND';

INST_ID SID SERIAL# SPID USERNAME PROGRAM
---------- ---------- ---------- ---------- ---------- ---------------------------------------------
1 30 15 3859 TEST sqlplus@oel5-11gr2.localdomain (TNS V1-V3)
1 23 287 3834 SYS sqlplus@oel5-11gr2.localdomain (TNS V1-V3)
1 40 387 4663 oracle@oel5-11gr2.localdomain (J000)
1 38 125 4665 oracle@oel5-11gr2.localdomain (J001)

why is the v$ Views with gv append infront of it?

http://www.oracle-base.com/articles/misc/KillingOracleSessions.php

Report message to a moderator

Re: v$session view [message #521703 is a reply to message #521702]

Thu, 01 September 2011 05:12

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

For RAC multi-instance.

Regards
Michel

Report message to a moderator

Re: v$session view [message #521771 is a reply to message #521703]

Thu, 01 September 2011 22:54

hanner
Messages: 90
Registered: August 2011
Location: at HOME

Member

I C.... the answer is written there but yet i failed to understand that. Thank you very much. Just need to re- confirm what i read at times.

Guess single instance we can no need to append that.

Laughing

Report message to a moderator

Previous Topic:	How to find non-indexed queries and columns that require indexes
Next Topic:	Create database (2 Merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Aug 20 00:22:40 CDT 2025