Re: Bequeath connections
Date: Wed, 27 Jan 2010 22:26:52 -0800 (PST)
On Jan 27, 9:18 pm, vsevolod afanassiev
> 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$
select username, osuser, process, program
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