Database link session in Active Session History
Hi,
Question about 11.1.0.7 on IBM AIX 6.1
I have a database which connects to another database over database link. One of my scheduler job was hung for many days for which i can see the records in dba_hist_active_sess_history where it is waiting for more data over database link. Now, i need to find a corresponding session in my remote database so that i could actually find where it was spending time on my remote database. Can anyone give me an idea that how to correspond this session from history with a session in remote database sessions history? In remote database, the module and action columns for dba_hist_active_sess_history show "oracle@IBMAIX04 (TNS V1-V3)" which is my host name from where my scheduler job connected to it, but, i have a lot of other jobs and applications connect with this database over db link and these columns show same value for all sessions so i can't find a session which i am actually looking for.
Only way which i am thinking, could be: if i can find the OS process ID from the sessions history in my local database and then i can find the session on remote database's sessions history based on this OS id (just like the process column in the v$session which shows client's OS process ID).
Any one who can guide how to do this.
Thanks in advance
Salman