DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=DrqqlJ6gXs7iVhV53yAiIqNK7GSrm69J+imLWznpxI46mPG+stTnFCLrFChTThUEsHKWR9huQWAJEFdS7zt5U3/BNnnb/WaCmvxMbxGJRayaKQNUp3eGBn91zsNTqKk9qlEUkkHn8Uje/9L3WVbiRVTsIyfB1YAP7Os3cnPeKsA=
Message-ID: <a8f0771c0702020047r1130c47dp6d091036e4771798@mail.gmail.com>
Date: Fri, 2 Feb 2007 10:47:02 +0200
From: "Edgar Chupit" <chupit@gmail.com>
To: JDunn@sefas.com
Subject: Re: Finding out what user oracle is installed under
Cc: oracle-l <oracle-l@freelists.org>
In-Reply-To: <2F802216565E44489600A03F763219A80BC4CF@mia.SEFASBRISTOL>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Disposition: inline
References: <2F802216565E44489600A03F763219A80BC4CF@mia.SEFASBRISTOL>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: chupit@gmail.com

There is a OSUSER column in v$session. You can query v$session for a
background process or for a current session, for example, using
following query:

select osuser from v$session where program like '%(SMON)%'

On 2/2/07, John Dunn <JDunn@sefas.com> wrote:
>
>
> 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 Dunn
>
>
> Product Consultant
>
> Sefas Innovation Limited
>
> Direct Dial + 44 (0) 117 373 6122
>
> www.sefas.com
>
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44
> (0) 117 373 6114 Fax: +44 (0) 117 373 6115
>
> Sefas Innovation Limited.  Registered No: 3769761 England.  Registered
> Office: One New Street, Wells, Somerset, BA5 2LA, United Kingdom.  VAT
> Registration No: GB 741 5377 32
>
> Unless stated to be non-confidential, this email and any attachments are
> private and confidential and are for the addressee only. Sefas monitors
> e-mails to ensure its systems operate effectively and to minimize the risk
> of viruses. Whilst Sefas has taken reasonable steps to scan this email, it
> does not accept liability for any virus that may be contained in it.
>
> Internet communications are not 100% secure and as such Sefas is not
> responsible for their abuse by 3rd parties, nor for any alteration or
> corruption in transmission.
>
>
>


-- 
Best regards,
 Edgar Chupit
 callto://edgar.chupit
--
http://www.freelists.org/webpage/oracle-l