OraFAQ Forum: Server Administration » Query to find the hostname for an Oracle Session

Home » RDBMS Server » Server Administration » Query to find the hostname for an Oracle Session

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

Query to find the hostname for an Oracle Session [message #457038]

Thu, 20 May 2010 19:15

shijumic
Messages: 31
Registered: May 2010

Member

How I can find the hostname for an oracle session id?

Thanks in Advance!

Report message to a moderator

Re: Query to find the hostname for an Oracle Session [message #457039 is a reply to message #457038]

Thu, 20 May 2010 19:17

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How I can find the hostname for an oracle session id?
Which hostname?
Client hostname, application server hostname, DB server hostname?

There is more than 1 system involved.

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

Report message to a moderator

Re: Query to find the hostname for an Oracle Session [message #457045 is a reply to message #457039]

Thu, 20 May 2010 20:53

shijumic
Messages: 31
Registered: May 2010

Member

Sorry about being not specific. Yes there is more than 1 system included. I get some alert logs that has an oracle session id that creates a blocking lock. Sometimes I have to kill the running process on some machines to deal with that. How I can find the client machine that belongs to a sessionID?

Report message to a moderator

Re: Query to find the hostname for an Oracle Session [message #457046 is a reply to message #457045]

Thu, 20 May 2010 21:01

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/
ALWAYS
Post Operating System (OS) name & version for DB server system.
Post results of
SELECT * from v$version
or post Oracle version to 4 decimal places

> How I can find the client machine that belongs to a sessionID?
As you well know computers are very detail oriented.
With regards the client machine, is this a 2 tier or 3 tier architecture?
Does the end user client machine connect directly to DB server (2-tier)
or is client machine running a web browser which connect to application server which talks to DB server (3-tier)?

Report message to a moderator

Re: Query to find the hostname for an Oracle Session [message #457302 is a reply to message #457038]

Sun, 23 May 2010 08:12

manojkb
Messages: 16
Registered: March 2006
Location: Dubai

Junior Member

This may work

SELECT SID, terminal 
FROM v$session
WHERE SID = &SID

Report message to a moderator

Previous Topic:	Install oracle 10G on win 7
Next Topic:	10.2.0.4 upgrade

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun May 19 12:52:10 CDT 2024