Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL> set autotrace traceonly explain Cannot SET AUTOTRACE

alinuxJan 3 2011 — edited Jan 4 2011
why is this happening.

SQL> set autotrace traceonly explain
Cannot SET AUTOTRACE


I have:
QL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod
PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

SQL>


and it works on chose optimizer.


Please help.


Thanks

Edited by: alinux on Jan 3, 2011 4:18 PM
This post has been answered by sb92075 on Jan 3 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 1 2011
Added on Jan 3 2011
#general-database-discussions
7 comments
4,507 views