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: 68761
Registered: March 2007
Location: Saint-Maur, France, https...
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: Fri Jul 18 12:48:05 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.