Home » Other » General » How long my query will have to run
How long my query will have to run [message #232054] Thu, 19 April 2007 04:05 Go to next message
dannywcw
Messages: 24
Registered: March 2007
Junior Member
Hi all, I'm using TOAD as my SQL tool. When i run my query, how can i check how long it will take to execute?
Re: How long my query will have to run [message #232058 is a reply to message #232054] Thu, 19 April 2007 04:17 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
dannywcw wrote on Thu, 19 April 2007 11:05
Hi all, I'm using TOAD as my SQL tool. When i run my query, how can i check how long it will take to execute?


Laughing That's rather impossible. It depends on too many factors that are undetermined prior to the run.

MHE
Re: How long my query will have to run [message #232059 is a reply to message #232054] Thu, 19 April 2007 04:18 Go to previous messageGo to next message
dannywcw
Messages: 24
Registered: March 2007
Junior Member
because one option is i can see from "Long_Ops" but this does not display the amount of time for the whole sql query.
Re: How long my query will have to run [message #232060 is a reply to message #232059] Thu, 19 April 2007 04:21 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

How on earth would you ever know that ?

If you run 50km will you know the exact time when your finsihed before you finished ?

[Updated on: Thu, 19 April 2007 04:22]

Report message to a moderator

Re: How long my query will have to run [message #232062 is a reply to message #232060] Thu, 19 April 2007 04:24 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Well Toad's Help tells you that

Quote:
Long Ops Details
This is data from V$SESSION_LONGOPS for the currently selected sessions. Oracle defines long ops as operations that run for longer than six seconds in absolute time, including some backup and recovery functions, statistics gathering, and query execution. For more information about what is included in Long Ops, please see your Oracle documentation.

To view Long Ops details

Click on the Sessions tab, if it has not been selected.

Select one or more sessions from the sessions tree view in the top panel.

In the bottom panel, click the Long Ops tab.

Note: You may have to scroll through the tabs in the bottom panel to see the Long Ops tab.

Percent Column Calculation
The Percent column is calculated as:

decode(totalwork, 0, 0, round(100 * sofar/totalwork, 2))


[Updated on: Thu, 19 April 2007 04:25]

Report message to a moderator

Re: How long my query will have to run [message #232069 is a reply to message #232054] Thu, 19 April 2007 04:41 Go to previous messageGo to next message
dannywcw
Messages: 24
Registered: March 2007
Junior Member
thanks mate
Re: How long my query will have to run [message #232196 is a reply to message #232062] Thu, 19 April 2007 14:58 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Also you have to remember that generally SQL statement may have from 0..N long operations where N is ~(query time in seconds / 6).
See more in my paper about long operations at http://www.gplivna.eu/papers/v$session_longops.htm

Gints Plivna
http://www.gplivna.eu
Previous Topic: Segments
Next Topic: Business Advantages of Oracle
Goto Forum:
  


Current Time: Thu Dec 08 18:40:46 CST 2016

Total time taken to generate the page: 0.04967 seconds