Print Thread
Page 1 of 2 1 2
Cannot set autotrace
#13235 01/29/04 04:34 PM
Joined: Sep 2003
Posts: 2
J
Ju Offline OP
Member
OP Offline
Member
J
Joined: Sep 2003
Posts: 2
I tried to run the following command in PL/SQL Developer 5.1.62, in a command window:
set autotrace on (traceonly, etc.)

The response was:
Cannot set autotrace

In SQL*PLUS from Oracle this works just fine.
Please give me some directions on how to use it in PL/SQL Developer

Re: Cannot set autotrace
#13236 01/29/04 08:48 PM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
This command is not supported in the Command Window. For a complete list of supported SQL*Plus commands, see chapter 7.3 in the User's Guide.

To obtain the information generated by the autotrace command, you can execute your SQL or PL/SQL in a SQL Window or Test Window. If the "Automatic Statistics" preference is enabled (Tools > Preferences > Options tab page), you can see all resource statistics that the Oracle Server provides on the "Statistics" tab page.


Marco Kalter
Allround Automations
Re: Cannot set autotrace
Marco Kalter #34200 06/15/09 11:51 AM
Joined: Sep 2004
Posts: 476
Munich, Germany
Member
Offline
Member
Joined: Sep 2004
Posts: 476
Munich, Germany
Hello Marco,

it would probably be useful to list also the valid SQL*Plus commands that are unsupported in pl-sql-developer command-window in the pl-sql-developer manual, like i.e. SET AUTOTRACE ...
It would be good if that command worked the same way as in SQL*Plus though. Is that possible for a future version? In my humble opinion as many as possible of the features in SQL*Plus should be available as well in pl-sql-developer command-window. I think a lot of users like to develop and test using the pl-sql-developer command-window but the result later on has to be executed somewhere else in SQL*Plus then, where it's expected to work the same way.

Last edited by Bernhard S; 06/15/09 11:55 AM. Reason: made it more clear

Regards,
Berny
Re: Cannot set autotrace
Marco Kalter #37316 02/16/10 07:26 PM
Joined: May 2003
Posts: 118
B
Member
Offline
Member
B
Joined: May 2003
Posts: 118
Marco,
any plans to get this one to work in Command window?
thank you
Andrew

Re: Cannot set autotrace
Babo #37322 02/17/10 12:50 PM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
This is on the list of enhancement requests. I don't have a date yet.


Marco Kalter
Allround Automations
Re: Cannot set autotrace
Marco Kalter #42665 11/08/11 10:32 PM
Joined: Jun 2004
Posts: 89
J
Member
Offline
Member
J
Joined: Jun 2004
Posts: 89
Marco,
Any idea when SET AUTOTRACE... will be included?

Thanks.

Re: Cannot set autotrace
jking #42670 11/09/11 11:16 AM
Joined: Aug 1999
Posts: 22,200
Member
Offline
Member
Joined: Aug 1999
Posts: 22,200
Not really. As stated above, the SQL Window and Test Window provide much more insight into resource statistics.


Marco Kalter
Allround Automations
Re: Cannot set autotrace
Marco Kalter #48752 03/11/14 05:10 PM
Joined: Sep 2013
Posts: 11
R
Member
Offline
Member
R
Joined: Sep 2013
Posts: 11
Please include the AUTOTRACE setting in the newer version.. it's the version 10 and this command cannot be used.
Thanks

Re: Cannot set autotrace
Roger25 #48754 03/12/14 12:56 AM
Joined: Feb 2013
Posts: 251
UTC+10
I
Member
Offline
Member
I
Joined: Feb 2013
Posts: 251
UTC+10
Function like "Run command in SQL*Plus" in TOAD would be OK. I guess it's not very hard to implement but would cover all the issues.

PLD provides more information, but autotrace does it in more common way to the community, which is important for discussing stuff on forums.

Re: Cannot set autotrace
IvanZ #48755 03/12/14 06:17 AM
Joined: Sep 2013
Posts: 11
R
Member
Offline
Member
R
Joined: Sep 2013
Posts: 11
So I should try using TOAD, for this AUTOTRACE?
Thanks

Page 1 of 2 1 2

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.041s Queries: 16 (0.009s) Memory: 2.5579 MB (Peak: 3.0393 MB) Data Comp: Off Server Time: 2024-04-20 08:25:12 UTC
Valid HTML 5 and Valid CSS