Re: Bequeath connections

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Thu, 28 Jan 2010 08:48:53 +0100
Message-ID: <4b614166$0$6721$9b4e6d93_at_newsspool2.arcor-online.net>

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 Received on Thu Jan 28 2010 - 01:48:53 CST