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@xxxxxxxxx> 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