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

Home » RDBMS Server » Server Administration » v$session (2 Merged)

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

v$session (2 Merged) [message #537909]

Mon, 02 January 2012 20:28

skjoshi500
Messages: 2
Registered: December 2011

Junior Member

Hi All,

I was going through the v$session dynamic view in oracle 10g.But I couldn't understand the values of the various columns like SADDR, PADDR. can anyone please help to understand what are these values, on what basis these values are assigned to a session or a process?

I'll be very much thankful, if you can help me to learn the actual meanings(not as in oracle doc.) of the various columns in the above mentioned view.

Thanks

Report message to a moderator

Re: Oracle Session [message #537911 is a reply to message #537909]

Mon, 02 January 2012 20:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

when all else fails, Read The Fine Manual

http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_3016.htm#sthref3552

Report message to a moderator

Re: Oracle Session [message #537912 is a reply to message #537911]

Mon, 02 January 2012 21:19

skjoshi500
Messages: 2
Registered: December 2011

Junior Member

Hi BlackSwan,
Thanks for your quick response, but can you please explain the actual meaning of these columns(SADDR,PADDR), means how these values are assigned to a particular session (SADDR) or to a particular Process(PADDR)

Report message to a moderator

Re: Oracle Session [message #537916 is a reply to message #537912]

Mon, 02 January 2012 21:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

SADDR & PADDR are unique identifiers assigned by SEQUENCE.
What is street address?
What is IP address?
What does it matter how any address is assigned as long as it is a unique identifier?

Report message to a moderator

Previous Topic:	function with user
Next Topic:	Cant install SQLT - user cant log in

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 17 05:29:10 CDT 2025