Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Finding out what user oracle is installed under
This will return account that is RUNNING Oracle instance and not
installed but that's what you probably asked. On one site we were
running several Oracle instances and each from it's own account that's
part of the dba Unix group while software installed as another user
(oracle).
On 2/2/07, Nigel Thomas <nigel_cl_thomas_at_yahoo.com> wrote:
> SQL> select osuser from v$session where program like '%PMON%'
-- Best regards, Alex Gorbachev The Pythian Group Sr. Oracle DBA http://www.pythian.com/blogs/author/alex/ http://blog.oracloid.com -- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 02 2007 - 07:25:50 CST