How to find user's current running sql query ?

The below script shows user's current running sql query :

----------------------------------------------------------------------

select sql_text from v$sqlarea                                                                                        where (address, hash_value) in (select sql_address, sql_hash_value from v$session 
where username like '&username');

Tweet

Related Posts You might be Interested:

Do you like this post? Please share this article.

HTML Link Code:

<a href="http://marthadba.blogspot.com/2016/08/how-to-find-users-current-running-sql.html">How to find user's current running sql query ?</a>

• email
• facebook
• linkedin
• twitter
• reddit
• google+