Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle process id to username

Status
Not open for further replies.

smacattack

Technical User
Jun 25, 2001
102
GB
I am looking for a way to identify a apps server process to the oracle database and then eventually to the username.
I have a process id from a solaris apps server, the process id relates to a f60webmx process.
I want to be able to identify which user this process belongs to.
Any ideas how I match all the process id's , solaris and oracle to find oracle username.

thanks
 

Check "process" from v$session. [noevil]

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 

PS:

Code:
Select PROCESS, USERNAME, OSUSER From V$Session;
[censored]

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top