[TOAD for ORACLE] How to see elapsed time popup window while executing query

[tadicg]

Hello,

when I run query I would like to see the window which shows me how
long is this query running.

For now I can see only execution time after the query is completed,
but I would like to see also elapsed time.

Kind regards

Goran

[Jeff Smith-7]

I was going to say, use the 'Query Viewer' tab, but it doesn't update the Execution time while the query is running, only after it's done.

Not sure you can do this today..

From: toad@... [mailto:toad@...] On Behalf Of tadicg
Sent: Friday, July 18, 2008 9:26 AM
To: toad@...
Subject: [toad] [TOAD for ORACLE] How to see elapsed time popup window while executing query


Hello,

when I run query I would like to see the window which shows me how
long is this query running.

For now I can see only execution time after the query is completed,
but I would like to see also elapsed time.

Kind regards

Goran


 
 

[Ed Klinger]

It sounds like you are using "threaded queries"  Options-->Oracle-->Transactions
- "Execute queries in threads"

With that checked you don't get the popup box.  To see elapsed time you will
need to go to the "Query Viewer" tab in the editor in the lower portion by the
data tab.  If you don't see it right-click by the data tab and select it from
the Desktop panels menu.

If you uncheck Threaded Queries then the popup will show up again.

Ed
[TeamT]

-----Original Message-----
From: toad@... [mailto:toad@...] On Behalf Of tadicg
Sent: Friday, July 18, 2008 9:26 AM
To: toad@...
Subject: [toad] [TOAD for ORACLE] How to see elapsed time popup window while
executing query

Hello,

when I run query I would like to see the window which shows me how
long is this query running.

For now I can see only execution time after the query is completed,
but I would like to see also elapsed time.

Kind regards

Goran


------------------------------------

Questions?  Try the on-line FAQ:
http://asktoad.com/DWiki/doku.php?id=faq:questions

Trouble downloading or running the freeware update? See
http://asktoad.com/DWiki/doku.php/howto_install_and_update_freetoad

Do you know about the other TOAD Yahoo Message Boards?  Go here to find out more
- http://www.toadsoft.com/maillist.htmYahoo! Groups Links




********************************************************************************************
Notice of Confidentiality: This e-mail communication and the attachments hereto,
if any, are intended solely for the information and use of the addressee(s) identified
above and may contain information which is legally privileged and/or otherwise confidential.
If a recipient of this e-mail communication is not an addressee (or an authorized
representative of an addressee), such recipient is hereby advised that any review,
disclosure, reproduction, re-transmission or other dissemination or use of this e-mail
communication (or any information contained herein) is strictly prohibited. If you are
not an addressee and have received this e-mail communication in error, please advise the
sender of that circumstance either by reply e-mail or by telephone at [phone]
immediately delete this e-mail communication from any computer and destroy all physical
copies of same.

Replies Filtered: Any incoming e-mail reply to this communication will be electronically
filtered for "spam" and/or "viruses."   That filtering process may result in such reply
being quarantined (i.e., potentially not received at our site at all) and/or delayed in
reaching us. For that reason, we cannot guarantee that we will receive your reply and/or
that we will receive it in a timely manner. Accordingly, you should consider sending
communications to us which are particularly important or time-sensitive by means other
than e-mail.
********************************************************************************************

[Ed Klinger]

Ah you are right.  Has that changed.  I thought at one time the query viewer
showed an elapse time.

Ed
[TeamT]

  _____  

From: toad@... [mailto:toad@...] On Behalf Of Jeff Smith
Sent: Friday, July 18, 2008 10:34 AM
To: toad@...
Subject: RE: [toad] [TOAD for ORACLE] How to see elapsed time popup window while
executing query



I was going to say, use the 'Query Viewer' tab, but it doesn't update the
Execution time while the query is running, only after it's done.

 

Not sure you can do this today..

 

From: toad@... [mailto:toad@...] On Behalf Of tadicg
Sent: Friday, July 18, 2008 9:26 AM
To: toad@...
Subject: [toad] [TOAD for ORACLE] How to see elapsed time popup window while
executing query

 

Hello,

when I run query I would like to see the window which shows me how
long is this query running.

For now I can see only execution time after the query is completed,
but I would like to see also elapsed time.

Kind regards

Goran

 


********************************************************************************************
Notice of Confidentiality: This e-mail communication and the attachments hereto,
if any, are intended solely for the information and use of the addressee(s) identified
above and may contain information which is legally privileged and/or otherwise confidential.
If a recipient of this e-mail communication is not an addressee (or an authorized
representative of an addressee), such recipient is hereby advised that any review,
disclosure, reproduction, re-transmission or other dissemination or use of this e-mail
communication (or any information contained herein) is strictly prohibited. If you are
not an addressee and have received this e-mail communication in error, please advise the
sender of that circumstance either by reply e-mail or by telephone at [phone]
immediately delete this e-mail communication from any computer and destroy all physical
copies of same.

Replies Filtered: Any incoming e-mail reply to this communication will be electronically
filtered for "spam" and/or "viruses."   That filtering process may result in such reply
being quarantined (i.e., potentially not received at our site at all) and/or delayed in
reaching us. For that reason, we cannot guarantee that we will receive your reply and/or
that we will receive it in a timely manner. Accordingly, you should consider sending
communications to us which are particularly important or time-sensitive by means other
than e-mail.
********************************************************************************************

[Jeff Smith-7]

If you only have 1 statement, F5 will show you what you want, but it will include the row retrieval process for ALL the records too I believe

From: toad@... [mailto:toad@...] On Behalf Of Ed Klinger
Sent: Friday, July 18, 2008 10:43 AM
To: toad@...
Subject: RE: [toad] [TOAD for ORACLE] How to see elapsed time popup window while executing query



Ah you are right.  Has that changed.  I thought at one time the query viewer showed an elapse time.

Ed
[TeamT]

________________________________
From: toad@... [mailto:toad@...] On Behalf Of Jeff Smith
Sent: Friday, July 18, 2008 10:34 AM
To: toad@...
Subject: RE: [toad] [TOAD for ORACLE] How to see elapsed time popup window while executing query
I was going to say, use the 'Query Viewer' tab, but it doesn't update the Execution time while the query is running, only after it's done.

Not sure you can do this today..

From: toad@... [mailto:toad@...] On Behalf Of tadicg
Sent: Friday, July 18, 2008 9:26 AM
To: toad@...
Subject: [toad] [TOAD for ORACLE] How to see elapsed time popup window while executing query


Hello,

when I run query I would like to see the window which shows me how
long is this query running.

For now I can see only execution time after the query is completed,
but I would like to see also elapsed time.

Kind regards

Goran





********************************************************************************************

Notice of Confidentiality: This e-mail communication and the attachments hereto,

if any, are intended solely for the information and use of the addressee(s) identified

above and may contain information which is legally privileged and/or otherwise confidential.

If a recipient of this e-mail communication is not an addressee (or an authorized

representative of an addressee), such recipient is hereby advised that any review,

disclosure, reproduction, re-transmission or other dissemination or use of this e-mail

communication (or any information contained herein) is strictly prohibited. If you are

not an addressee and have received this e-mail communication in error, please advise the

sender of that circumstance either by reply e-mail or by telephone at [phone]

immediately delete this e-mail communication from any computer and destroy all physical

copies of same.



Replies Filtered: Any incoming e-mail reply to this communication will be electronically

filtered for "spam" and/or "viruses."   That filtering process may result in such reply

being quarantined (i.e., potentially not received at our site at all) and/or delayed in

reaching us. For that reason, we cannot guarantee that we will receive your reply and/or

that we will receive it in a timely manner. Accordingly, you should consider sending

communications to us which are particularly important or time-sensitive by means other

than e-mail.

********************************************************************************************


 
 

[tadicg]

Thank you guys... that was what I meant but if I press cancel it don't terminate... it still working.

Kind regards
Goran



----- Original Message ----
From: Jeff Smith <jeff.smith@...>
To: "toad@..." <toad@...>
Sent: Friday, July 18, 2008 4:49:09 PM
Subject: RE: [toad] [TOAD for ORACLE] How to see elapsed time popup window while executing query


If you only have 1 statement, F5 will show you what you want,
but it will include the row retrieval process for ALL the records too I believe
 
From:toad@yahoogroups. com [mailto:toad@ yahoogroups. com] On Behalf Of Ed
Klinger
Sent: Friday, July 18, 2008 10:43 AM
To: toad@yahoogroups. com
Subject: RE: [toad] [TOAD for ORACLE] How to see elapsed time popup
window while executing query
 
 
Ah you are right.  Has that changed.  I thought at one
time the query viewer showed an elapse time.

Ed
[TeamT]
 

________________________________
 
From:toad@yahoogroups. com [mailto:toad@ yahoogroups. com] On Behalf Of Jeff Smith
Sent: Friday, July 18, 2008 10:34 AM
To: toad@yahoogroups. com
Subject: RE: [toad] [TOAD for ORACLE] How to see elapsed time popup
window while executing query
I was going to say, use the ‘Query
Viewer’ tab, but it doesn’t update the Execution time while the query is
running, only after it’s done.
 
Not sure you can do this today..
 
From:toad@yahoogroups. com [mailto:toad@ yahoogroups. com] On Behalf Of tadicg
Sent: Friday, July 18, 2008 9:26 AM
To: toad@yahoogroups. com
Subject: [toad] [TOAD for ORACLE] How to see elapsed time popup window
while executing query
 
Hello,

when I run query I would like to see the window which shows me how
long is this query running.

For now I can see only execution time after the query is completed,
but I would like to see also elapsed time.

Kind regards

Goran
 
 
************ ********* ********* ********* ********* ********* ********* ********* ********* ********
Notice of Confidentiality: This e-mail communication and the attachments hereto,
if any, are intended solely for the information and use of the addressee(s) identified
above and may contain information which is legally privileged and/or otherwise confidential.
If a recipient of this e-mail communication is not an addressee (or an authorized
representative of an addressee), such recipient is hereby advised that any review,
disclosure, reproduction, re-transmission or other dissemination or use of this e-mail
communication (or any information contained herein) is strictly prohibited. If you are
not an addressee and have received this e-mail communication in error, please advise the
sender of that circumstance either by reply e-mail or by telephone at [phone]
immediately delete this e-mail communication from any computer and destroy all physical
copies of same.
 
Replies Filtered: Any incoming e-mail reply to this communication will be electronically
filtered for "spam" and/or "viruses."   That filtering process may result in such reply
being quarantined (i.e., potentially not received at our site at all) and/or delayed in
reaching us. For that reason, we cannot guarantee that we will receive your reply and/or
that we will receive it in a timely manner. Accordingly, you should consider sending
communications to us which are particularly important or time-sensitive by means other
than e-mail.
************ ********* ********* ********* ********* ********* ********* ********* ********* ********