Re: SYS_CONTEXT DBLINK_INFO returns null over db link

Select property_value from Databae_properties_at_remotedb Where property_name='GLOBAL_DB_NAME';

Karth

> On Mar 3, 2014, at 12:22 PM, "Rich Jesse" <rjoralist3_at_society.servebeer.com> wrote:
>
> 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-l
>
>

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