Re: Bequeath connections

From: ddf <>
Date: Wed, 27 Jan 2010 22:26:52 -0800 (PST)
Message-ID: <>

On Jan 27, 9:18 pm, vsevolod afanassiev
<> 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


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

Original text of this message