OraFAQ Forum: General » How long my query will have to run

Home » Other » General » How long my query will have to run

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How long my query will have to run [message #232054]

Thu, 19 April 2007 04:05

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?

Report message to a moderator

Re: How long my query will have to run [message #232058 is a reply to message #232054]

Thu, 19 April 2007 04:17

Maaher
Messages: 7065
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?

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

MHE

Report message to a moderator

Re: How long my query will have to run [message #232059 is a reply to message #232054]

Thu, 19 April 2007 04:18

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.

Report message to a moderator

Re: How long my query will have to run [message #232060 is a reply to message #232059]

Thu, 19 April 2007 04:21

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

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

dannywcw
Messages: 24
Registered: March 2007

Junior Member

thanks mate

Report message to a moderator

Re: How long my query will have to run [message #232196 is a reply to message #232062]

Thu, 19 April 2007 14:58

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

Report message to a moderator

Previous Topic:	Segments
Next Topic:	Business Advantages of Oracle

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 21:28:34 CDT 2024