I created a procedure and I am trying to test it. It compiles and I run it. When I go into Instance manager I see that I am logged in but it doesn't show any query running. When I look at the screen where I executed my query it is just sitting there like it is running but it isn't. Does anyone have any ideas on how I can check if my query is running. If it isn't, does anyone have any ideas as to why it would just sit there?
select * from v$session
Find the session that is running your stored procedure. If the STATUS column = 'ACTIVE', then it is running a query. If it
is INACTIVE, then the session is not currently running a query.
SELECT * FROM V$SESSION_WAIT
Try to look into this view v$sqlarea.I am sure it will give u ur desire information and pass your userid as parameter with parsing_user_id.