check on a query?

[lesstjm]

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?

[jdorlon]

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.

-John

[sonaliak]

Check..
SELECT * FROM V$SESSION_WAIT

[mayank]

Hi lesstjm,

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.

Thanks,

Mayank