Re: Bequeath connections

From: ddf <oratune_at_msn.com>
Date: Wed, 27 Jan 2010 22:26:52 -0800 (PST)
Message-ID: <5e75745d-5f3b-4dfc-9014-1c152ebb38e8_at_2g2000prl.googlegroups.com>

On Jan 27, 9:18 pm, vsevolod afanassiev
<vsevolod.afanass..._at_gmail.com> wrote:
> I have been given access to a certain database at Oracle level, but no
> UNIX access.
> Is it possible to determine whether a connection (Oracle session) is
> Bequeath connection or connection through listener by looking at V$
> views?
> Thanks

Possibly:

select username, osuser, process, program from v$session
where username is not null
and machine = (select host_name from v$instance);

You may see some emagent sessions which won't be listed as BEQ connections (at least not by ps -ef) but it will show you all of the local connections bearing actual user names.

David Fitzjarrell Received on Thu Jan 28 2010 - 00:26:52 CST