Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Database link session in Active Session History

Salman QureshiOct 26 2010 — edited Oct 3 2012
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 31 2012
Added on Oct 26 2010
6 comments
4,206 views