remote sessions (database link, v$session)...

Hi!

I have two databases: base01 and base02. base01 often queries base02 through a database link (e.g. : (from base01) select * from mytable_at_base02).

One session is created on base01 and an other session is created on base02.
(I know that by querying V$SESSION on both bases).

I'd like to base02 to know the session_id of the session which was created on base01 while querying...
A kind of table which could match :
- the local SESSION_ID on base02

• the SESSION_ID of the session opened by base01

I don't see any columns/dynamic views which could allow me to join e.g. v$session_at_base01 et v$session_at_base02.

Do you see any possibilities ????

Thanks ;) Received on Wed Dec 14 2005 - 12:49:42 CST