Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Finding out what user oracle is installed under

Re: Finding out what user oracle is installed under

From: Alex Gorbachev <gorbyx_at_gmail.com>
Date: Fri, 2 Feb 2007 08:25:50 -0500
Message-ID: <c2213f680702020525v1cb78d01x91ec5eb0e37d7d38@mail.gmail.com>


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-l
Received on Fri Feb 02 2007 - 07:25:50 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US