Database Tuning (MOSC)

MOSC Banner

one procedure is executing since long and waiting on sql*net message from db link

edited Jan 14, 2014 3:02AM in Database Tuning (MOSC) 1 commentAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center