>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