Home » Other » General » Query status
Query status [message #320927] Fri, 16 May 2008 14:59 Go to next message
Messages: 312
Registered: July 2007
Location: INDIA
Senior Member

Dear all,

when query is running,how would u check the status of the query?

(like how long it will take to complete )

kindly revert me with the answer.

Re: Query status [message #320928 is a reply to message #320927] Fri, 16 May 2008 15:02 Go to previous message
Michel Cadot
Messages: 63917
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If it is running, status is active.
How long you may or may not know it, it depends on the query execution plan.
Query v$longops to get the current query operation but only if it is a long operation.

Previous Topic: Regarding the 10g downloads from Oracle !!
Next Topic: Just Pondering
Goto Forum:

Current Time: Tue Oct 25 01:52:44 CDT 2016

Total time taken to generate the page: 0.09288 seconds