OraFAQ Forum: Server Administration » Process in V$SESSION

Home » RDBMS Server » Server Administration » Process in V$SESSION

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

Process in V$SESSION [message #244739]

Thu, 14 June 2007 00:39

gajini
Messages: 262
Registered: January 2006

Senior Member

Hi,

The columns PROCESS in V$SESSION,for some sessions it's containing
the value like "2536:2100", instead of exact OS prcoess id.

What does it mean? How do I've to get the exact OS prcoess id using
this value?

My OS is AIX & Oracle version 9.2.0.8

Thanks...

Report message to a moderator

Re: Process in V$SESSION [message #244771 is a reply to message #244739]

Thu, 14 June 2007 01:37

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

Senior Member
Account Moderator

Quote:

2536:2100

This is the process ID of your client which is on Windows as this is the way windows named its processes.

Regards
Michel

Report message to a moderator

Re: Process in V$SESSION [message #244782 is a reply to message #244771]

Thu, 14 June 2007 02:02

gajini
Messages: 262
Registered: January 2006

Senior Member

Thanks Michel,

Now I got it..

Report message to a moderator

Previous Topic:	db_file_multiblock_read_count - reading too less blocks at a time
Next Topic:	ORA-16014

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 12:29:39 CST 2024