Query to find the SQL text of running procedure

                                                                                                                                                                      

Scenario:

How to find which query part/query of Procedure is running?

Solution:

select module, a.sid,machine, b.SQL_TEXT,piece

from v$session a,v$sqltext b

where status='ACTIVE'

and a.SQL_ADDRESS=b.ADDRESS

--and a.USERNAME='NAME'

and sid=95

order by sid,piece;