Home » Other » General » Query status
Query status [message #320927] Fri, 16 May 2008 14:59 Go to next message
balaji1482
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: 64130
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.

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


Current Time: Wed Dec 07 06:57:52 CST 2016

Total time taken to generate the page: 0.13470 seconds