Skip to Main Content

SQLcl: MCP Server & SQL Prompt

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!

no output from autotrace

Jochen BandhauerMar 16 2026

Hi,

it seems that there is no autotrace output if I have alter session statements in the login.sql file.

For example having:

alter session set nls_date_format='dd.mm.yyyy hh24:mi:ss';
alter session set plsql_warnings='ENABLE:ALL';

in the login.sql in the base directory of sqlcl shows no autotrace output:

SQL> set autot on
Autotrace Enabled
Shows the execution plan as well as statistics of the statement.
SQL> select * from dual;
DUMMY
________
X
1 row selected.
Elapsed: 00:00:00.029
SQL> version
Oracle SQLDeveloper Command-Line (SQLcl) version: 25.4.2.0 build: 25.4.2.044.1837

SQL>

Jochen

This post has been answered by thatJeffSmith-Oracle on Mar 16 2026
Jump to Answer
Comments
Post Details
Added on Mar 16 2026
2 comments
31 views