Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 25023 invoked from network); 2 Feb 2007 02:46:00 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 2 Feb 2007 02:46:00 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2381F5CBCF5; Fri, 2 Feb 2007 03:44:49 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28580-09; Fri, 2 Feb 2007 03:44:49 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 317CD5D04D7; Fri, 2 Feb 2007 03:44:47 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 02 Feb 2007 03:43:33 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DD1D45D0007 for ; Fri, 2 Feb 2007 03:43:32 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28227-02-2 for ; Fri, 2 Feb 2007 03:43:32 -0500 (EST) Received: from web58711.mail.re1.yahoo.com (web58711.mail.re1.yahoo.com [66.196.100.188]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 4194B5CE7C3 for ; Fri, 2 Feb 2007 03:43:31 -0500 (EST) Received: (qmail 39327 invoked by uid 60001); 2 Feb 2007 08:44:42 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:MIME-Version:Content-Type:Message-ID; b=uLnez0hFaVM7DZsnNDbGr4h7AYPOGqe30He+xd4oYbbcpQc1YRJsuGJUUohelVR+CNsESuSnHSoh4snowH+DAvl4ubKQ/xERD+FopR/DXbCRZF+WMCJxPIIZWPU3NEQLbyNz6abEq85BKrkScgwqL26RdJLx1zTm1OpcB8bmKPA=; X-YMail-OSG: 5U1kOuMVM1lzHkCVuRHc8pq3kWuqSt8FyxRHne0yy.p3r._wBOSsRjpkYohJvLuQGOMqkica5HokyzbWvOTtrAcmCsybGkBCdgyPhPIULAfN4W7lpKhCJ3G.yH9YD0d5KQrREqmHZkspmdB1uy39Nl.pra.t9GaSvHSvtmEW9itSRg6TVi4_Hdgc1QdH Received: from [149.254.120.136] by web58711.mail.re1.yahoo.com via HTTP; Fri, 02 Feb 2007 00:44:41 PST Date: Fri, 2 Feb 2007 00:44:41 -0800 (PST) From: Nigel Thomas Subject: Re: Finding out what user oracle is installed under To: oracle-l , John Dunn MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-581665851-1170405881=:38155" Message-ID: <947596.38155.qm@web58711.mail.re1.yahoo.com> X-archive-position: 45065 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: nigel_cl_thomas@yahoo.com Precedence: normal Reply-to: nigel_cl_thomas@yahoo.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net --0-581665851-1170405881=:38155 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable >Is there a database query that will tell me what Unix account oracle is in= stalled under? =0A>I know that in most cases this will be oracle, but is th= ere a database query that will tell me?=0A=0AJohn=0A=0ASQL*Plus: Release 8.= 0.6.0.0 - Production on Fri Feb 2 08:42:04 2007=0A(c) Copyright 1999 Oracle= Corporation. All rights reserved.=0A=0AConnected to:=0AOracle9i Enterpris= e Edition Release 9.2.0.7.0 - 64bit Production=0AJServer Release 9.2.0.7.0 = - Production=0A=0ASQL> =0ASQL> select osuser from v$session where program l= ike '%PMON%'=0A 2 /=0A=0AOSUSER=0A------------------------------=0Aoracom= =0ASQL> =0A=0AOr better still try ... where SID =3D 1=0A=0AObviously you ne= ed access to v$session...=0A=0ARegards Nigel --0-581665851-1170405881=:38155 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
=0A
>Is there a database query that will tell me what Unix= account oracle is installed under?
=0A
>I know that in = most cases this will be oracle, but is there a database query that will tel= l me?
=0A
 
=0A
John
=0A
&nbs= p;
SQL*Plus: Release 8.0.6.0.0 - Production on Fri Feb 2 08:42:04 2007=
=0A
(c) Copyright 1999 Oracle Corporation.  All rights r= eserved.
=0A

Connected to:
Oracle9i Enterprise Edition = Release 9.2.0.7.0 - 64bit Production
JServer Release 9.2.0.7.0 - Product= ion
=0A
 
=0A
SQL>
SQL> select osu= ser from v$session where program like '%PMON%'
  2  /
=0A=
 
=0A
OSUSER
------------------------------oracom
=0A
SQL>
=0A
 
=0A
Or better still try ... where SID =3D 1
=0A
Obviously you= need access to v$session...
=0A

Regards Nigel
= --0-581665851-1170405881=:38155-- -- http://www.freelists.org/webpage/oracle-l