SYS_CONTEXT DBLINK_INFO returns null over db link
From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Mon, 3 Mar 2014 11:22:25 -0600 (CST)
Message-ID: <a1b17773ea60282abf2dfeb9659c90bd.squirrel_at_society.servebeer.com>
Hey all,
Date: Mon, 3 Mar 2014 11:22:25 -0600 (CST)
Message-ID: <a1b17773ea60282abf2dfeb9659c90bd.squirrel_at_society.servebeer.com>
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_at_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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Mar 03 2014 - 18:22:25 CET