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.