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.