Re: Finding out what user oracle is installed under

From: Nigel Thomas <nigel_cl_thomas@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>, John Dunn <JDunn@xxxxxxxxx>
Date: Fri, 2 Feb 2007 00:44:41 -0800 (PST)

>Is there a database query that will tell me what Unix account oracle is 
>installed under? 
>I know that in most cases this will be oracle, but is there a database query 
>that will tell me?

John

SQL*Plus: Release 8.0.6.0.0 - Production on Fri Feb 2 08:42:04 2007
(c) Copyright 1999 Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit Production
JServer Release 9.2.0.7.0 - Production

SQL> 
SQL> select osuser from v$session where program like '%PMON%'
  2  /

OSUSER
------------------------------
oracom
SQL> 

Or better still try ... where SID = 1

Obviously you need access to v$session...

Regards Nigel

Follow-Ups:

Re: Finding out what user oracle is installed under
From: Alex Gorbachev

Re: Finding out what user oracle is installed under

Other related posts: