one procedure is executing since long and waiting on sql*net message from db link
Below is the session and the user is saying he has executed a procedutre and it's running since long.First the sqltext from the sql id is giving a select statement .How do I know that this session is a prcoedure execution because I think it would give only the sql statements executing inside the procedure
select prev_sql_id,blocking_session,last_call_et,username,osuser,event,sql_id from v$session where status='ACTIVE' and username<>'SYS';
9nh6hyj3xzy7f 87293 PES oracle SQL*Net message from dblink a6v3hbfn607w7
Next is what can I do to remove the SQL*NET message from db link wait.The last_call_et is 87239 and when I see the database links used in the query -I logged in to those databases but didn't find any long running session from the users to which these databasel inks connect.
0