Bernard Devlin wrote:

>
> SQL> select count(*) from events;
>
> COUNT 31182225
>
> Records affected: 1

The number of rows returned to the user

> Current memory = 84905984

Memory used by the server

> Delta memory = 9216

Difference between memory usage before and after the query

> Max memory = 85041240

Largest amount of memory used by the server during the query.

> Elapsed time= 116.81 sec

Wall clock time the query took to run.

> Cpu = 6.88 sec

CPU time the query took to run.

> Buffers = 10000

Number of cache buffers set in the configuration file - or however that
number was set - there are several options.

> Reads = 152925

Number of pages read from disk

> Writes = 0

Number of pages written to disk

> Fetches = 62670274
>

Number of page requests. The page could be any database page type -
data pages, index pages, pointer pages (the pages used to find data
pages in a table), etc. Both Reads and Fetches count pages read to
lookup metadata, etc. The same page is often requested several (many)
times. The difference between reads and fetchs is a hint of the
effectiveness of the cache.


Regards,


Ann