SQL*Plus (MOSC)

MOSC Banner

autotrace shows much less statistics using sqlplus compared to sqlcl

in SQL*Plus (MOSC) 3 commentsAnswered ✓

I run the same commands to execute a query with autotracing in both sqlplus and sqlcl.

The same settings in sqlcl print out much more statistics measurements. How can the same amount of measurements be achieved in sqlplus?

$ sqlplus system/PW@HOST/SERVICE

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Aug 8 10:47:10 2024
Version 19.22.0.0.0

SQL> set autotrace on
...

Statistics

 34  recursive calls
  0  db block gets
 494132  consistent gets
  0  physical reads
  0  redo size
552  bytes sent via SQL*Net to client
436  bytes received via SQL*Net from client
  2  SQL*Net roundtrips to/from client
  0  sorts (memory)
  0  sorts (disk)
  1  rows processed

Executing the same in sql(cl):

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center