check on a query?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: check on a query?

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    515
    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?

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    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

  3. #3
    Join Date
    Jan 2001
    Posts
    318
    Check..
    SELECT * FROM V$SESSION_WAIT
    Sonali

  4. #4
    Join Date
    May 2001
    Posts
    1

    Talking

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width