sql_id in gv$sql was not appearing in gv$session
Hi Team,
We had an issue in our database (11.2.04) recently where an user initiated several update statements for a table. We could see the update statements and Lock table statements in GV$SQL view but those sql_ids were not present in GV$SESSION view. Since there were no user sessions associated with those SQL_IDs, we couldnt kill it. Had to bounce the instance to get rid of those update queries and lock tables. So I am curious to understand,
- Why there was no user session associated with the sql_id that was present in GV$SQL
- How to stop those DML statements or LOCK table statements without bouncing the instance.