FreeLists / oracle-l / Re: Finding out what user oracle is installed under

["Edgar Chupit" <chupit@xxxxxxxxx>]

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