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.

Report message to a moderator

Re: Query status [message #320928 is a reply to message #320927] Fri, 16 May 2008 15:02 Go to previous message
Michel Cadot
Messages: 68637
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 16 15:16:39 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.