Solved

Check Status of Oracle Query

Posted on 2009-06-29
3
937 Views
Last Modified: 2012-05-07
Can anyone tell me how to check the status of a long running query (Oracle 10g)?
0
Comment
Question by:iBinc
  • 2
3 Comments
 
LVL 40

Assisted Solution

by:mrjoltcola
mrjoltcola earned 200 total points
Comment Utility
You can start with the V$SESSION_LONGOPS view

You can join it against the V$SQL view to get the text of the query.
0
 
LVL 40

Assisted Solution

by:mrjoltcola
mrjoltcola earned 200 total points
Comment Utility
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 300 total points
Comment Utility
what type of status are you looking for?  

you can try something like this if you want to see what the query's session is waiting on.

SELECT   s.sid, sw.event
  FROM   v$session s, v$session_wait sw
 WHERE   sw.sid = s.sid
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now