SYS_CONTEXT DBLINK_INFO returns null over db link

  • From: "Rich Jesse" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 3 Mar 2014 11:22:25 -0600 (CST)

Hey all,

In 11.2.0.3, I'm trying to determine where a query over a dblink originated
using:

SELECT
        SYS_CONTEXT('USERENV','DBLINK_INFO')
FROM DUAL@REMDB;

...but it always returns a NULL.  This is documented at:

http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions184.htm

Anyone know where else I could get this info?  Well, other than X$ tables as
specified in:
http://jkstill.blogspot.com/2010/03/whos-using-database-link.html
Not sure I want to go there if'n I don't have to...

TIA!

Rich

--
//www.freelists.org/webpage/oracle-l


Other related posts: