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
