dbTalk Databases Forums  

Length of SQL execution in SQL plus

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Length of SQL execution in SQL plus in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Norbert Pürringer
 
Posts: n/a

Default Length of SQL execution in SQL plus - 11-13-2006 , 11:44 AM






Hello!

I need to know the length of the execution of an SQL statement in Oracle SQL
worksheet. I know there is a command to set a flag on but I do not remember
the name of the command anymore.

Regards,
Norbert


Reply With Quote
  #2  
Old   
Mark D Powell
 
Posts: n/a

Default Re: Length of SQL execution in SQL plus - 11-13-2006 , 12:22 PM








On Nov 13, 12:44 pm, Norbert Pürringer <thalio... (AT) graffiti (DOT) net>
wrote:
Quote:
Hello!

I need to know the length of the execution of an SQL statement in Oracle SQL
worksheet. I know there is a command to set a flag on but I do not remember
the name of the command anymore.

Regards,
Norbert
When you know a feature exists but cannot remember what it is then pull
the documentation. What you want is the timing option of the set
command:

set timing on

HTH -- Mark D Powell --



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.