ALTER SYSTEM SET events 'trace[rdbms.SQL_Optimizer.*][sql:9s5u1k3vshsw4]' ALTER SYSTEM SET events 'trace[rdbms.SQL_Optimizer.*][sql:9s5u1k3vshsw4] off' https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=368303807596291&id=19708342.8&_adf.ctrl-state=1b44p4xesv_237 README ------ Name: SQL Developer SQLcl Desc: Oracle SQL Developer Command Line (SQLcl) is a free command line interface for Oracle Database. It allows you to interactively or batch execute SQL and PL/SQL. SQLcl provides in-line editing, statement completion, and command recall for a feature-rich experience, all while also supporting your previously written SQL*Plus scripts. Version: 20.4.1 Build: 20.4.1.351.1718 Release Notes ============= Ansiconsole as default SQLFormat -------------------------------- From SQLcl 20.2, AnsiConsole Format is on by default. This means that certain features will not work as expect until the format is set to default. These include the SQL\*Plus features * HEADING * TTITLE * BREAK * COMPUTE SQL> set sqlformat default. If you have extensive use of SQL\*Plus style reports, you need to unset sqlformat via login.sql or add it to your reports