SQL$HELP_OLD72.HLB  —  SHOW  Arguments  STATISTICS
    Displays simple process statistics for the current process. This
    command is used primarily to compare resource usage and elapsed
    time for different queries.

    The following example shows the output after performing a typical
    query:

    SQL> select count (*)
    cont> from employees natural full outer join job_history;

          274
    1 row selected
    SQL> show statistics;

                      process statistics at 5-MAR-2006 05:57:48.28
             elapsed time = 0 00:00:00.16               CPU time =  0 00:00:00.05
         page fault count = 430             pages in working set = 22768
       buffered I/O count = 26                  direct I/O count = 83
          open file count = 12              file quota remaining = 7988
               locks held = 138                  locks remaining = 16776821
          CPU utilization = 31.2%            AST quota remaining = 995

    The statistics are reset after each execution of the SHOW
    STATISTICS command.
Close Help