statistics of a query

[Roger25]

Hi,

Which command can we use (if it exists, of course), to display a query's statistics like:

Statistics
---------------------------------------------------
          0  recursive calls
          0  db block gets

        421  consistent gets

          0  physical reads
          0  redo size
        371  bytes sent via SQL*Net to client
        430  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          0  sorts (memory)
          0  sorts (disk)
          1  rows processed

This is shown in SQL Plus with "set autotrace traceonly" before executing a query, but in PL/SQL Developer we cannot set autotrace.

Thank you.

 

[Marco Kalter]

You can enable "Automatic Statistics" (Tools > Preferences > Oracle / Options). When enabled you can execute a statement in the SQL Window or Test Window and go to the "Statistics" tab page to view the information.

See chapter 6.2 in the User's Guide for more information.