Re: Bequeath connections

From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Thu, 28 Jan 2010 11:15:06 -0800 (PST)
Message-ID: <44e2191c-c955-4d94-8114-b058b4f5a39f_at_f12g2000yqn.googlegroups.com>



On Jan 28, 2:48am, Maxim Demenko <mdeme..._at_gmail.com> wrote:
> On 28.01.2010 03:18, 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
>
> You can look at v$session_connect_info:
>
> SQL> connect system
> Enter password: ******
> Connected.
> SQL> select network_service_banner from v$session_connect_info where
> sid=sys_context('userenv','sid');
>
> NETWORK_SERVICE_BANNER
> ----------------------------------------------------------------------------------------------------
> Oracle Bequeath NT Protocol Adapter for Linux: Version 10.2.0.4.0 -
> Production
> Oracle Advanced Security: authentication service for Linux: Version
> 10.2.0.4.0 - Production
> Oracle Advanced Security: encryption service for Linux: Version
> 10.2.0.4.0 - Production
> Oracle Advanced Security: crypto-checksumming service for Linux: Version
> 10.2.0.4.0 - Production
>
> SQL> connect system_at_emrep
> Enter password: ******
> Connected.
> SQL> select network_service_banner from v$session_connect_info where
> sid=sys_context('userenv','sid');
>
> NETWORK_SERVICE_BANNER
> ----------------------------------------------------------------------------------------------------
> TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.4.0 - Production
> Oracle Advanced Security: encryption service for Linux: Version
> 10.2.0.4.0 - Production
> Oracle Advanced Security: crypto-checksumming service for Linux: Version
> 10.2.0.4.0 - Production
> Oracle Advanced Security: crypto-checksumming service for Linux: Version
> 10.2.0.4.0 - Production
>
> Best regards
>
> Maxim

I had forgotten all about this view. It is pretty easy to modify the where clause using a like to find all connections using TCP/IP or Bequeath.

HTH -- Mark D Powell -- Received on Thu Jan 28 2010 - 13:15:06 CST

Original text of this message