Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Finding out what user oracle is installed under
>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
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 02 2007 - 02:44:41 CST